Method 'Columns' of object 'IImexGrid' failed.

[jb]

I received this error message trying to import data from an excel
spreadsheet. I've gone back to spreadsheet to ensure there aren't any data
elements that don't match the columns datatype.

This is part of an import I've been doing almost daily for several months
and this is the first time it is not working. Any ideas what this error
message is about?

Thanks,

jb

 

[Jeanette Cunningham]

Hi,
The problem lies somewhere in that particular worksheet.
Check the excel file you are trying to import.
There can be problems with formats on the worksheet.
There can be problems with empty cells in Excel with time formats.
There can be problems with the way the worksheet is set up.
To check this, in excel, select the worksheet by clicking on the empty
square at the intersection of the top of the row numbers and the left most
of the column headings.
Go Ctl + End and see where the worksheet ends. By default Access will import
all the cells that you can see selected - there may be some problem with
empty cells with formats that are a problem for Access to import or that don't
match the fields in your import table.
Try selecting just the cells you want to import

Check that the column headings match the field names in access with no stray
spaces or strange characters.
Check if the worksheet is protected, remove protection and try again.

Here is a recent comment from the newsgroup:
I did insert grid marks on this excel spreadsheet, which I had not on the
previous 48 files I had imported. I removed all of the extra formatting and
it worked.

Jeanette Cunningham