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
 
Top