Export Access table to excel using macro

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.
 
T

Tom van Stiphout

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
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Exporting to Excel from Access 3
Macro/Export Delimited 3
Refresh and run Excel macro 7
Macro - Access 8
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
export to exce spread sheet 1

Top