Search Key was not found on any record

matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

Search Key was not found on any record

Post by matthewR »

I am using Access 2010. I am trying to import an excel spreadsheet into Access. I keep getting, "The Search Key was not found on any record".

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Search Key was not found on any record

Post by HansV »

Check the field names (column headers) in the spreadsheet - make sure that they don't contain leading or trailing spaces (preferably no spaces at all).
Best wishes,
Hans

BenCasey
4StarLounger
Posts: 495
Joined: 13 Sep 2013, 07:56

Re: Search Key was not found on any record

Post by BenCasey »

Quite often it is the indexing of the DB which is at fault with this type of error. Try Compact/repair on the FE and BE (if you have one) and then try again once you have done the checks that Hans mentioned.
Regards, Ben

"Science is the belief in the ignorance of the experts."
- Richard Feynman

matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

Re: Search Key was not found on any record

Post by matthewR »

I just retyed the headings and that seemed to do the trick. Thank you. Very frustrating.