Automating exporting data from Access to Excel

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
 
I

Immanuel Sibero

Hi Freddie,

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

HTH,
Immanuel Sibero
 
C

c

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.
 

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

Exporting Data to Excel 2
Exporting filtered data to Excel 3
Exporting data between excel files 1
Exporting Data from Access To Excel 10
exporting data from Access to Excel using VBA 1
Export to XML - error 31532 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Text columns exporting to currency columns 5

Top