Adam
Glad you got it working. And thanks for posting the cause and solution.
Don't you just love meaningless error messages? Access can't work with Excel versions of a later release. I run into problems all the time with that since most of my apps are created in 2003 and users are gradually moving up to Office 2010. I just don't have the time to convert all my apps. The ones I've tried just doing a straight conversion without changing anything never seem to make it without a bunch of little bugs running around.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "AdamF" <runuphillracing@...> wrote:
>
> Mystery solved. The file was created as another version of Excel. It worked when I saved it as an Excel97-2003 file.
>
> Adam
>
> --- In MS_Access_Professionals@yahoogroups.com, "AdamF" <runuphillracing@> wrote:
> >
> > Bill,
> >
> > It works manually, no indicators to point me anywhere. Only one sheet. It's a file created from a process that extracts data from another system. There is no way to connect the systems via ODBC.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> > >
> > > Adam
> > >
> > > What happens if you manually import the data? Maybe something will show you what's going wrong.
> > >
> > > If you had more than one sheet and one was set as a named range and later deleted, you might have to specify the sheet that has the data.
> > >
> > > DoCmd.TransferSpreadsheet acImport, , "ShippingExtract", _
> > > "g:\TMM\ShippingExtract.xls", True, "Sheet1$"
> > >
> > > Note the dollar sign at the end of the sheet's name.
> > >
> > >
> > > Regards,
> > > Bill Mosca, Founder - MS_Access_Professionals
> > > http://www.thatlldoit.com
> > > Microsoft Office Access MVP
> > > https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> > > My nothing-to-do-with-Access blog
> > > http://wrmosca.wordpress.com
> > >
> > >
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "AdamF" <runuphillracing@> wrote:
> > > >
> > > > 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 (10) |
Tidak ada komentar:
Posting Komentar