export to excel

G

Guest

I have a query that makes a table. I want a macro that will open the table
and export it to excel and save it on a server. Is there an easy way to do
this? I do not see how to send it as a spreadsheet. Thanks,
 
K

Ken Snell [MVP]

Check out the TransferSpreadsheet action. It will export a table or query
into an EXCEL file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to Excel 3
Exporting to Excel from Access 3
export to excel and save 4
Automating export to Excel 4
Refresh and run Excel macro 7
Export Records Into Existing Excel File 1
Contact Info Export to Excel with Multiple Phone Numbers 2
Import to many to many table 7

Top