• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

Access error loading Excel data

Get the following error "Search key not found in any record" when importing Excel 2007 data into Access 2007. All field names have no blanks.
0
jtruffa
Asked:
jtruffa
  • 3
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
The Excel file must be in a "List/Table" structure.

Basically:
No blank rows in between rows of data
No Blank columns in between columns of data
Field Names in row 1
No Jagged edges to the data.
No stray text in numeric fields
No hidden columns
No leading spaces in call values

Also try the import into a brand new blank Access 2007 database.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
You can also post this Excel file here, and I can try importing it to an Access 2007 DB on my machine.
0
 
jtruffaAuthor Commented:
Thanks, you solved my problem.
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now