exporting a table to Excel

[SheriTingle]

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 !

 

[Van T. Dinh]

Have you checked the other arguments in the TransferSpreadsheet Macro
action.

 

[SheriTingle]

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.

 

[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?