A2K Error 3011 on TransferSpreadsheet method

#1

Hello all,

I'm jut trying to import a spreadsheet into a table in Access 2000.

The spreadsheet is called cc-ledgcodebalances.xls with no field names.

My code is

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, "tmptmp",
VFileName, 0

This seemed to work once but since then I now get this;

The Microsoft Jet database engine could not find the object
''cc-ledgcodebalances$''. Make sure the object exists and that you spell
its name and the path name correctly. 3011

Google searches aren't really turning up much that is useful. I'm trying to
import the whole thing and I don't think this is to do with named ranges.

Bit stumped by this, any help?

#2

"buckskin" <buckskin (AT) mailinator (DOT) com> wrote in
news:8ic1buFj70U1 (AT) mid (DOT) individual.net:

Quote:

The spreadsheet is called cc-ledgcodebalances.xls with no field
names.

My code is

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3,
"tmptmp", VFileName, 0

This seemed to work once but since then I now get this;

The Microsoft Jet database engine could not find the object
''cc-ledgcodebalances$''. Make sure the object exists and that
you spell its name and the path name correctly. 3011

Google searches aren't really turning up much that is useful. I'm
trying to import the whole thing and I don't think this is to do
with named ranges.

Most likely the spreadsheet or table structure no longer matches
that of the saved import spec. I've gotten the same message in that
scenario.

Try it with the import wizard and it should tell you what's wrong
with the saved import spec when you load it.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#3

"David-W-Fenton" <NoEmail (AT) SeeSignature (DOT) invalid> wrote

Quote:

"buckskin" <buckskin (AT) mailinator (DOT) com> wrote in
news:8ic1buFj70U1 (AT) mid (DOT) individual.net:

The spreadsheet is called cc-ledgcodebalances.xls with no field
names.

My code is

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3,
"tmptmp", VFileName, 0

This seemed to work once but since then I now get this;

The Microsoft Jet database engine could not find the object
''cc-ledgcodebalances$''. Make sure the object exists and that
you spell its name and the path name correctly. 3011

Google searches aren't really turning up much that is useful. I'm
trying to import the whole thing and I don't think this is to do
with named ranges.

Most likely the spreadsheet or table structure no longer matches
that of the saved import spec. I've gotten the same message in that
scenario.

Try it with the import wizard and it should tell you what's wrong
with the saved import spec when you load it.

Many thanks for that David, seems to be working now as I'm having to import
a different spreadsheet. But I'll bear that tip in mind.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

A2K Error 3011 on TransferSpreadsheet method

comp.databases.ms-access comp.databases.ms-access

A2K Error 3011 on TransferSpreadsheet method - 10-21-2010 , 06:40 PM

Re: A2K Error 3011 on TransferSpreadsheet method - 10-22-2010 , 06:59 PM

Re: A2K Error 3011 on TransferSpreadsheet method - 10-26-2010 , 09:12 AM