ACCESS FEED: RE: [MS_AccessPros] RT error 7890, file doesn't contain any data

Rabu, 19 Juni 2013

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

Are you sitting on the right datasheet?

Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of AdamF
Sent: Wednesday, June 19, 2013 12:52 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.