Error importing from Excel message "The search key was not found"

L

Lady_Dee

In the process of trying to import a Excel spreadsheet, over 5,000 records, I
received the error message "The search key was not found". Mind you, I am
trying to import records, I am not looking for a record. Please help
 
J

Jerry Whittle

Sounds like the spreadsheet might be a little corrupt. Instead of importing,
link to the spreadsheet. Then you can use an append or create table query to
insert the records into 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

Dumb question alert! What program to use? 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Import Wizard Error Message "The search key was not found in any r 2
Access 2007 error: The search key was not found in any record 2
Error importing from Excel 1
What is a search key to import Excel to Access? 2
Search key not found 2

Top