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 !
 
Ad

Advertisements

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.
 
Ad

Advertisements

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

Top