Access 2007 Excel Import Error

[rba1012]

I'm trying to import an Excel spreadsheet into Access 2007 and keep getting
"The search key was not found in any record." error message. I have deleted
all blank rows, columns, tabs, formatted all the data to match Access, etc.

What is this "search key"?

 

[Song]

I'm trying to import an Excel spreadsheet into Access 2007 and keep getting
"The search key was not found in any record." error message.  I have deleted
all blank rows, columns, tabs, formatted all the data to match Access, etc.

What is this "search key"?

At the bottom of this link, someone find the solution
http://www.access-programmers.co.uk/forums/showthread.php?t=92702