Page 1 of 4 1234 LastLast
Results 1 to 15 of 47
  1. #1
    virtualprg is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2009
    Posts
    4

    The search key was not found in any record

    I am attempting to import an Excel spreadsheet into an Access database. Other spreadsheets have worked but I get an error message as above when I import.



    I have no clue about the problem.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What version of Access are you using?

  3. #3
    virtualprg is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2009
    Posts
    4
    Both the spreadsheet and the Access database are in 2007 versions.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you applied Office 2007 SP1 and the HotFix that goes with it?

  5. #5
    virtualprg is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2009
    Posts
    4
    Current on all updates and fixes.

    I was actually able to import the file into Access using Data Loader Enterprise Edition.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So is this issue resolved?

  7. #7
    virtualprg is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2009
    Posts
    4
    A workaround was found but I am curious the problem. I don't know what a 'search key' is. The spreadsheet clearly existed as I was able to complete all except the final step in the import wizard.

  8. #8
    mick_curtis is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    1

    Remove field names

    Remove field names and do the import - hoping that the wizard does not suggest 'indexes Yes' for any fields.


    Something I do a lot with excel is to make all its fields text before doing an import - might be useful.

  9. #9
    didacbr is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    1

    spaces before names of field

    When I eliminate the problem disappear

  10. #10
    selahlynch is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    2
    I too had this problem...
    and deleting spaces from my titles fixed the problem.

  11. #11
    Ikester is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2010
    Posts
    1
    Thanks for that folks! Your suggestion to remove any prefixed space characters solved the problem for me! That was a head-scratcher! Any MS advice focused on a bug recommending a Jet driver update ... which doesn't apply to Vista. Very cryptic error msg that MS would be wise to clarify ... or just deal with the space characters by removing them?

  12. #12
    MHenry is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Apr 2010
    Posts
    1

    Search Key

    Well I'll be darned - I messed around with a 25+ column spreadsheet for like 45 minutes before duh, I goggled it. These postings were spot on. I had one column with a space before the first character. Imported into a table like a charm after that. In 7 years I've never encountered that error.

  13. #13
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Which is why the archives are maintained. Glad they were useful for you.

  14. #14
    accessbuff is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2010
    Posts
    2

    Wink nice data import tip

    this thread is one of the best in terms of issues that can be encountered in data importation...........particularly on converting everything to text first in order to avoid errors.

    Thanks Guys!


  15. #15
    sarahji is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    6

    Still not working...

    Hey all,

    I'm getting the same error when importing a spreadsheet from Excel into Access 2007. I tried changing all the fields to text and making sure there are no spaces in the field names/ column headers. No luck!

    Any suggestions?

    Gracias!

Page 1 of 4 1234 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 10-16-2008, 02:39 PM
  2. if record not found through combo box
    By wasim_sono in forum Forms
    Replies: 2
    Last Post: 08-04-2008, 06:32 AM
  3. Deleting Record Contents, not complete record...
    By Charles Waters in forum Access
    Replies: 2
    Last Post: 06-24-2008, 12:00 PM
  4. Search All Field
    By robbiebrown34 in forum Access
    Replies: 0
    Last Post: 05-17-2007, 09:40 AM
  5. Search for record from a form
    By hcoakley in forum Forms
    Replies: 0
    Last Post: 11-26-2006, 11:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums