Importing Excel Data - Error Message

J

Jen Scott

I'm receiving the following error message when I try to import a MS Excel
2007 file into Access 2007 (into a new table):

The search key not found on any record. Then it tells me the file will not
be imported.

I've looked at the Excel file and don't see anything wrong with it -- any
suggestions? Thanks!
 
J

Jerry Whittle

They linking to the Excel worksheet instead. If that works, you can the use a
make table or append query based on the linked table.
 
D

De Jager

Jen Scott said:
I'm receiving the following error message when I try to import a MS Excel
2007 file into Access 2007 (into a new table):

The search key not found on any record. Then it tells me the file will
not
be imported.

I've looked at the Excel file and don't see anything wrong with it -- any
suggestions? Thanks!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Active Content in this file is blocked issue 1
MS Project Import Error Row 1 Column 5 2
Merging from an Excel file with graphics 1
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Save workbook without shapes 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Access 2007 Excel Import Error 1

Top