Solved

Access error loading Excel data

Posted on 2008-11-03
4
382 Views
Last Modified: 2013-11-27
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
Comment
Question by:jtruffa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 22874035
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22902249
You can also post this Excel file here, and I can try importing it to an Access 2007 DB on my machine.
0
 

Author Closing Comment

by:jtruffa
ID: 31512700
Thanks, you solved my problem.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22982031
;-)
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question