Import Wizard Error Message "The search key was not found in any r

B

Bmoler

I am receiving the error message " the search key was not found in any
record" from the Import Wizard when trying to import an Excel spreadsheet. I
am using version Access version 2007. If any one has any suggestions as to
what is going wrong I would appreciate it.
 
S

Stephanie

Oddly, I just got this error today when importing an Excel file that I had
saved as .txt. I just resaved the Excel file as .csv and got it to work.
You might try that. (Also, I was importing into a new table.)
 
K

Kaykayme

I also received this error when trying to import an Excel spreadsheet. I
found that by removing the spaces at the beginning of the Field Names in my
spreadsheet I was able to import the spreadsheet with no problem.
 

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

Error importing from Excel message "The search key was not found" 1
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Access 2007 error: The search key was not found in any record 2
Working outlook via vba code with xlsx - error 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
What is a search key to import Excel to Access? 2
Search key not found 2
>> Search Key 4

Top