Error importing from Excel

R

rcarolina

I am running 2007, trying to import a spreadsheet into access and getting an
error stating "search key was not found in any record". It is a simple
import and all the other datasheets imported just fine. I cannot see the
problem. I am a new Access user so be gentle.
These are the field names
EFIN RALS Fed ERD Fed ERC

Thanks,
 
J

JeffreyBee

I just experienced the same problem with an Excel workbook. So, I went back
into Excel and noticed that some of my field names had leading spaces. I
retyped all of my field names and made sure they had no spaces and then I was
able to import it into Access successfully.

I hope that works for you too.
 

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
Search Key Not Found Error 2
Access 2007 error: The search key was not found in any record 2
Error when importing Excel 07 sheet 0
Importing text into number field- Error 4
Importing a date and time from Excel 8
importing from Excel 2
error 3709 0

Top