Error importing from Excel

  • Thread starter Thread starter rcarolina
  • Start date Start date
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,
 
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.
 
Back
Top