Transfer database action a problem

S

SheriTingle

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 !
 

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

exporting a table to Excel 3
Password for Transfer Database 1
in Access 2007-TransferDatabase action will not work. 0
Export Report with Graph to Excel error 2495 1
Transfer Text - Decimal Places 0
cannot expand named range 1
object name doesn't follow microsoft access object naming rules 3
Macro syntax between Office 2003 and 2007 0

Top