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

Kamis, 20 Juni 2013

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

Liz,

"It sounds like you are" ... what?

No big rush. I'm not getting back to it for a couple of days.

Thanks
Adam

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> 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.
>