Importing from Excel to Access 2003

[jonfromdon]

Trying to import a spreadsheet called "Service Customers" from Excel 2003
into Access 2003 but keep getting a message that the Microsoft Jet engine
cannot locate the file "Service Customers$" - check name and location etc but
file exists and is correctly named. Where does this "$" come from?
Anyone help with this one please?

 

[Roger Carlson]

I don't know why this is happening. Odd things go on between Excel and
Access that you have no control over. If you just want to get it imported,
I'd try saving the Excel sheet as a CSV and import it that way.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[jonfromdon]

Roger
Thanks for that info - have now transferred the file with a few errors but
nothing critical - nows comes the fun of creating forms etc!
Kind regards

 

[Guest]

no i didt

I don't know why this is happening. Odd things go on between Excel and
Access that you have no control over. If you just want to get it
imported, I'd try saving the Excel sheet as a CSV and import it that way.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[viktor chuzhakin]

no i didt