exporting a table to Excel

G

Guest

Thanks for the help ! I am using Access XP. I have a table in Access that I
need to export to Excel. I'm trying to use the Transfer Database macro
command but I can't seem to get the syntax correct for the Excel spreadsheet.
Here's what I put: C:\Documents and Settings\JCNCBMC07\Desktop\Export.xls

What do I need? Or is there a better way to use a macro to transfer the table?

THANKS !
 
G

Guest

This is the only problem that appears with an error message. I took out all
of the other items to narrow it down to this error.
 
V

Van T. Dinh

You cannot leave other arguments blank.

Have you checked the path and made sure the path exists?

What is the error message?
 

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

Transfer database action a problem 1
Exporting Table to Specific Excel Worksheet 2
Export table to txt file with a variable filename 0
How to export table from outlook into ms access table? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Macro to Export Spreadsheet; Keeps Failing 1
Read only error when trying to export table using Macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top