A2K Error 3011 on TransferSpreadsheet method

Question

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?

Answer 1

I answered this elsewhere that you asked it:

The error you're getting often occurs when the saved import spec is out of synch with either the source data or the target table. Try starting the import with the wizard, then load the saved import spec and it will likely throw an error or reveal what's no longer accurate.