[MS_AccessPros] RT error 7890, file doesn't contain any data

 

I don't understand why I'm getting this message when trying to import from an Excel file, using the following code:
DoCmd.TransferSpreadsheet acImport, , "SalesExtract", "g:\TMM\SalesExtract.xls", True

The file DOES contain data. I use almost the same code to import another file, which does work.
DoCmd.TransferSpreadsheet acImport, , "ShippingExtract", "g:\TMM\ShippingExtract.xls", True

Can someone help?

Thanks
Adam

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2
• New Links 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___