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

Reading Metadata from Word Documents 0
Drop down list control value in vba 2
Autonumber field in Excel that behaves the same as Access 0
Sorting and filtering text 0
Use MACRO to export queries to specific SHEETs in ONE Excel file? 4
Images are pixelated when saving to PDF 0
Using Office Forms and dynamically updating the excel backend 0
How to export html text as word document with specific size and orientation 0

Top