Import Wizard (Excel correct format)

[ralphyehle]

I am trying to import an Excel2002 file into Access2002 using the import wizard. There is a hidden worksheet named 'Data' with 5 ranges defined (Page1-5), one of which I am trying to import: I am getting the following error message –

“Import Spreadsheet Wizard -- The wizard is unable to access information in the file ‘D:\xxxx.xls’. Please check that the file exists and is in the correct format.”

I have successfully imported other Excel files from the same folder, but using a different original file. The original Excel file giving me the trouble was created in 1999 but has been saved with Excel2002 version.

Can anyone tell me what causes the “correct format” error? I am confident it is something having to do with the Excel file. I've attached a zip file with the problem workbook.

Thanks in advance for any assistance.

 

[boblarson]

Well, for one I noticed that I had the same error but when I saved it in Excel 2007 in compatibility mode (Excel 97-Excel 2003) using SAVE AS it gave me an error message about formulas linked from other workbooks in the Err-Track sheet. So, it then recognized it when I went to try to import it, but I don't think you're going to get any good imports. The worksheets are not laid out for importing. If you need to get the data into Access from them, you should think about using the Excel Object Model instead.

 

[ralphyehle]

The spreadsheet I want to import various ranges from is hidden, and titled 'Data.' Example: "Data!A7:AC7"

I've successfully done this with another vary similar workbook which was originally designed in 2000 and saved as into the newer 2002 Excel format.

Hows the Excel Object Model work? I'll check the Access and Excel help files and see what they say.