Solved

Access error loading Excel data

Posted on 2008-11-03
4
377 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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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 specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now