CODEWITHSUNDEEP
ms-access
d3mo
d3mo

Reputation: 9

Microsoft Access - "Search key cannot be found"

Receiving error in title upon importing spreadsheet using import spreadsheet wizard. Option "Let Access add primary key." was chosen, after clicking finish, error message saying "Search key cannot be found" pops up and spreadsheet is not imported.

Upvotes: 0

Views: 3848

Answers (5)

andersonbma
andersonbma

Reputation: 1

I also found that this issue occurs if you have "frozen rows" at the top of the spreadsheet to import.

Upvotes: 0

Florin D
Florin D

Reputation: 1870

Had similar issue, seems like it was due to corruption of the DB. I tried the "Compact and Repair" option but did not help. Finally I created a new Access DB and was able to import the file.

Upvotes: 0

John
John

Reputation: 1

I had the issue, I could not get the data to import, so I linked to the file instead.

Upvotes: 0

user14289788
user14289788

Reputation: 11

I had this issue and it was due to a field in my access table that was "Long Text" and was Indexed. When I removed the Index, it fixed the issue.

Upvotes: 1

Lee Mac
Lee Mac

Reputation: 16015

This issue typically occurs when you have leading spaces in the column headings of the Excel spreadsheet being imported.

Upvotes: 1

Related Questions