Automating exporting data from Access to Excel

  • Thread starter Thread starter Freddie
  • Start date Start date
F

Freddie

Hi,

I've developed an Access 2002 database, where I need to
have the ability to automate exporting data from the
database to an Excel spreadsheet.

Does anyone know of a good source to complete this task?

Thanks in advance.

Sincerely,
Freddie
 
Hi Freddie,

Access help is good enough for this. Look up "TransferSpreadsheet".

HTH,
Immanuel Sibero
 
Hi,
Moving info to Excel is a simple macro to
in macro use "TransferSpreadsheet"

Tranfer type (Export for you)
Spreadsheet type (you choose)
Table Name (table or query name in access)
File Name (full path and file name)
Has field names (for putting field names in excel sheet
Range (can only be used on import)

Follow instructions on Help, for more.
 
Back
Top