Search Key not found on import to table

  • Thread starter Thread starter Puzzled
  • Start date Start date
P

Puzzled

I have received the above error many times recently when importing and XLS
spreadsheet into ACCESS. After checking all fields for naming and format,
still getting error. The only way I have been able to resolve the issue is
to eliminate some of the columns.

Thank you.
 
Puzzled said:
I have received the above error many times recently when importing and XLS
spreadsheet into ACCESS. After checking all fields for naming and format,
still getting error. The only way I have been able to resolve the issue is
to eliminate some of the columns.
Click to expand...

This message is usually a sign of corruption. Make a backup copy of
your MDB. Then do a compact and repair and see if that fixes your
problem.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

search key not found in any record 4
The Search Key was not found in any record... 0
Access 2007 Excel Import Error 1
Search Key Not Found????? 4
Search Key Was Not Found 1
Problem with import 2
Error importing from Excel message "The search key was not found" 1
importing xls with dates 2

Back
Top