Export Access table to excel using macro

  • Thread starter Thread starter mcp201
  • Start date Start date
M

mcp201

I wanted to know what would be the best way in exporting an Access table into
an excel spreadsheet using a macro????? Thanks in advance.
 
On Fri, 29 Aug 2008 07:21:01 -0700, mcp201

It's a one-liner: DoCmd.TransferSpreadsheet

-Tom.
Microsoft Access MVP
 

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
Remove borders when ms access 2007 performs an export to excel? 4
Import to many to many table 7
Refresh and run Excel macro 7
Exporting Access query to Excel file with passwords 6
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Exporting query to table in external database 4

Back
Top