I am trying to import a simple and small excel table (three columns: date, and two numeric values, ~150 rows) into an Access database to update a table (the Excel file represents new data and should be appended to the Access table). I have done this before – in fact, it was how the Access table was created, although with an early version of the Excel file with much more data (~2000 records).
When I click on File | Get External Data > Import and specify an Excel file (in XL 2003 format) and the file I want, I get an error message I have never seen:
[indent]
Method ‘Columns’ of object IImexGrid’ failed
[/indent]
If I click on “Okay” (the only choice), the spreadsheet import wizard seems to continue normally, and I can specify that the file should be imported to an existing table but the actual import fails, and I get a message that an error occurred in the import and the file was not imported. Has anyone run into this error, or have any idea what to do about it?
UPDATE
I just trried with a little (10 records) Excel file of fake data, and it was imported without problem. My data comes from a data-extraction tool run in another department, so there may be something odd about the excel file that they deliver it in, although there is nothing obviously different about it. If so, in the past I may have manipulated the data or cut / pasted it into a new file rather than trying to save and import from the original file. If worse comes to worst, I will be able to manualy re-create 150 records in a new XL file, but any insight will still be appreciated.
