Software

Ask something
Discussion Locked

Automating Export from Access to Excel

0 helpful
5 replies

by mcandreescu

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Trying to find an automated way to export query result (From Access) to formatted Excel Spreadsheet saved on local machine. I have tried linking and embedding-saving spreadsheet as another file. But each time the process runs, it tries to update all previous files when they are opened. This confuses users and I need to be able to keep previous results intact. Any ideas would be helpful as I am still learning!

5 replies

by dfowler

Not sure I understand exactly what you are trying to accomplish, but maybe this will help. Instead of "exporting" the results from Access, try using Microsoft Query with Excel to "import" from Access. MS Query will allow you to actually build the query in Excel (through the Data and Get External data menus) and specify the Access database (tables) where Excel is to pull the information from. Then, you save the file as a master. Whenever you want new results, open the master file, click the Refresh button and do a Save As so that you keep the master intact, as well as each update instance (previous results). This method will also allow you to format the spreadsheet ahead of time, and the imported data from the refresh function will conform to that formatting. I use this alot and find it quite handy and easy. Would be willing to provide more detail if you want to e-mail me directly.

This discussion is closed to new replies.