Error Message while Importing Data

J

Jen Scott

I'm getting the following error message when I try to upload a MS Excel 2007
file into Access 2007 --

The search key not found in any record.

What am I doing wrong? I upload files all of the time and have never had
this issue before. Thanks for your help!
 
G

Gina Whipp

Jen Scott,

Might be a field name issue... what are the field names on your Excel
Spreadsheet? Any spaces in them? Any special characters?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I'm getting the following error message when I try to upload a MS Excel 2007
file into Access 2007 --

The search key not found in any record.

What am I doing wrong? I upload files all of the time and have never had
this issue before. Thanks for your help!
 

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

MS Project Import Error Row 1 Column 5 2
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Outlook 365 Signatures 0
My computer will print from ALL other programs except MS publisher 2007 4
Publisher cannot create a working file 0
REINSTALLING MS OFFICE PRO PLUS 2019 0
Solved Disk Full error message when exporting PDF 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0

Top