I agree with you but for reasons that would take to long they want to do it in Excel, I didn't think you could but thought i would throw it out to the group to see if there was something i might have missed. Thanks
it might be do-able - but you would need someone who actually knows what they are talking about -
they guys here know access to a high degree and are experts - but Excel ?
have you tried xls help files -
- Personally I don't think its do-able
you could do a get round but thats probably more complicated
and would involve link sheets /workbooks
in essense have access -link to a spreadsheet have that spreedsheet the target of your xls links- but even this is gonna be prone to all sorts of cockups- and not so easy to manage
you could have a routine that automatical imports a target xls - but again you are doing this from access and not from xls
I have had a quick look and the help files don't help at all - i presume its not do-able-
however there is a software solution that can be purchased that says it can do this - but to be honest it looks like a variation of Ghudsons import solution - and again seems to be from Access end .
This is eminently doable ...
We can connect to an access database using ADO or DAO and fully manipulate the database (.mdb)
It's typically done when you want a multi-user database with an Excel front end.
Though it does depend on what you actually want to do with it.