exporting a table to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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 !
 
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.
 
You cannot leave other arguments blank.

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

What is the error message?
 
Back
Top