Unanswered: How to export Access Table and save as Excel file
I have just completed a huge ass database. And the output quer is a mkae table query Which save the output as a Table named "Final_Result". I wanted to know if there is any way to have Access save that Table as an excel table or workbook to a fixed location. i have a lot of queries so a macro runs all of them in a sequence, could the same macro do this task as well.
You can do it with a macro. In the Action field select "Output To" and set-up the arguments at bottom. For Output File, you can input something like C:\Temp\ExcelFile.xls or you leave it blank and it will bring up a Save As box for the user, which is more user-friendly since you don't know whether everyone has a C:\Temp folder they can write to.
The TransferSpreadsheet Method is an option, but I prefer taking an approach similar to Pootle's post as it allows much more flexibility and control over how the data is exported as compared to docmd.TransferSpreadsheet.