exporting data from Access to Excel using VBA

F

Freddie

Hi,

I am trying to automating from an Access 2002 database to
an Excel 2002 spreadsheet.

I've not been able to find articles thyat exlain how to
automate this process.

Does anyone have such information?

Freddie
 
J

John Vinson

Hi,

I am trying to automating from an Access 2002 database to
an Excel 2002 spreadsheet.

I've not been able to find articles thyat exlain how to
automate this process.

Does anyone have such information?
Click to expand...

Open the VBA editor (to get the right Help file) and search for help
on TransferSpreadsheet.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Automate export from Excel to Access 1
Automating exporting data from Access to Excel 2
Inserting Excel VBA into an Excel File while Exporting 2
VBA to create auto Export data from Access 2002 to Excel 2002 1
Creating an Excel spreadsheet via Access VBA 1
Convert .csv to .xls and Import VBA 4
Exporting from access to excel problem using vba. 1

Top