Can you let me know if it is possible to link a spreadsheet to a database without having to download all the data to the spreadsheet first.
What I am looking for is to keep a database of customers and then when entering details into a spreadsheet I can pull the addresses down from the database. The problem I have is I also want a way of adding new customers when required.
Please ask me any questions as I know I have not explained myself very well.
Thanks in advance.
I don't think you can easily do what you want - you can link Excel sheets into Access as tables but they are read-only in Access, and from Excel you can't see the Access data. It is possible to do this sort of thing using code, but it gets very complex very quickly, espically if you have a multi-user environment.
Do you have to use a spreadsheet? Could you store all the data in Access instead. You could still output the data to Excel quite easily for reference, but you'd update it in Access and the Excel sheet would not be automtically updated, you'd need to output a new one whenever you needed to make sure yu had themost up-to-date info.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks