Exporting Access to Excel

C

Chris

I want to know if there is a way to automate a macro or VBA for exporting
data into Excel. I'm not too familiar with Access or programming. I need all
the help I can get.

Chris
 
J

Jeanette Cunningham

Chris,
you can create a macro and choose transfer spreadsheet as the action.
When creating the macro you can get help on each part by pressing F1 when
you have the cursor in that part.

You might get a better result in the spreadsheet by creating a query to
export.
If the results in excel are not as you want, post back and we can help with
formatting calculated fields in the query.

Jeanette Cunningham
 
S

Steve Schapel

Chris,

In addition to Jeanette's suggestion regarding the TransferSpreadsheet
macro action, I would also suggest having a look at the OutputTo action,
which I find sometimes is better.
 

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

Problem in exporting the access 2007 report to excel 3
Macro: Exporting to Excel - Pre-naming Worksheet 3
Access 2000 Macro to Export to Excel fails in Access 2002 0
Exporting Queries to Excel 1
export MS Access report to MS Word on separate pages 1
ACCESS TO EXCEL 1
Exporting Data to Excel 2
exporting to excel - excel macro automatically runs after export!!? 1

Top