Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

search key was not found in any record - importing excel table into access

Status
Not open for further replies.

realtallgal

IS-IT--Management
Dec 10, 2008
20
0
0
US
I am trying to import a xls sheet into a new table in current ACCESS database. I am using the wizard am getting the error " the search key ws not found in any record". File was not imported. I went through my file and included a key identifier...do not know why it won't import.
please advise
 
hi,

Please post a sample of the table you are importing from Excel

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top