ADO Excel error - External Table not in expected format

[LARiot]

Hi and thanks any help on this.

I have ADO code that opens an excel file and imports into an Access table. This works fine on every excel file being imported except for one for which I get this error message:

Run-time error: '-2147467259 (8004005)':

External table is not in the expected format.

I've tried opening and saving the file from excel but it hasn't changed anything. Does anyone have an idea why this might be happening?

BTW, the code can be found here:

http://tek-tips.com/viewthread.cfm?qid=1430712&page=1

...however seeing as it works fine for some of the .xls files I can't imagine it needing change.

Thanks again.

-Neema

 

[LARiot]

Someone suggested that the file is saved in Excel 2007 format and this is a problem for Access 2003.

So I save the workbook in Excel 2003 format. It imports it fine until I reboot the machine. Then it gives me the same error.

Maybe I should call a witch doctor.

-Neema