Exporting query results to excel (1 Viewer)

[MickeyGreen]

I want to automate a process of exporting several simple queries to excel (and to overwrite the existing excel files). This has to be easy but I can't "record" the basic steps like I can in excel to get me started. can anyone help?

 

[reclusivemonkey]

Use the VBA help files. TransferSpeadsheet or OutputTo will help. Althout you may find it easier to "pull" the information out of Access via Excel if you are more familiar with Excel. Take a look at the "Data" --> "Import External Data" menu in Excel.

 

[x0reset]

If your not comfortable using VBA you can use the "TransferSpreadsheet" option in the macro builder. You may also find it helpful to know that exporting a spreadsheet with the same name as an existing spreadsheet will automatically overwrite the old version.

 

[MickeyGreen]

Thanks,

I got both the vba and macro methods to work. I think I like the vba version better because it's easier to update.