Importing data from excel error

[Frustrated in AL]

I attempted to import data to an access table. I have used the same excel
format to imort data to the same access table without issue before. I
received the following error:

"Method 'Columns' of object 'IImexGrid'failed".

Can someone please tell me what this means and how I can get my data to
import?

Thank you.

 

[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 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 if the worksheet is protected, remove protection and try again.

 

[Frustrated in AL]

Thank you for your response, Jeanette.

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.

I appreciate your help. Have a good weekend.