Transfer database action a problem

[Guest]

I'm using Access XP. I need to transfer a table from Access to Excel. I
thought the TransferDatabase action would be the approriate way to accomplish
this. I keep getting this error message when I run the macro: "The object
name 'C:\...xls' you entered doesn't follow Microsoft Access object-naming
rules."

This is the only action in this macro and there are no other messages so
this seems to be my problem. The path I have for Excel is as follows:

C:\Documents and Settings\JCNCBMC07\Desktop\Export.xls

I think when I've done this before there was an additional character(s) I
had to add to the path but I can't seem to remember it. Anyone know???

Thanks !

 

[Guest]

it's the transferspreadsheet action you want.