Ah - I've had issues where the first sheet was the default unless I explicitely stated the name of the sheet, but you answered my question. It sounds like you are.
I'm having a crazy busy morning so I probably won't check this thread for a while.
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 8:32 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] RT error 7890, file doesn't contain any data
Liz,
What do you mean by "sitting?" It is the right file, and there is only one worksheet in the file.
--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> 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.
>
------------------------------------
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.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar