Results 1 to 4 of 4
  1. #1
    bbxrider is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    69

    runtime error 3709 - The search key was not found in any record

    I have a excel file, a.xlsx that I successfully external data append to a table. I save the import as import1
    In a form the user can select the same file with a different name, I rename it to be the same file name the saved import is looking for, then I execute vba to run the import1 saved import,
    DoCmd.RunSavedImportExport ("import1") but get the 3709 error.


    so it works when importing the first time to save the import, but errors when I run the
    import via vba. I can run the external data import manually a second time with no error.
    nothing I google explain why this would be occurring in my case

  2. #2
    bbxrider is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    69
    ok found it, the workbook name and the sheet name have to be the same for the saved import to work,
    same as here, http://p2p.wrox.com/access-vba/81344...not-found.html. I was copying files with
    a different name to the saved import name, but didn't realize the sheet name had to be an exact match
    as well.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Thanks for posting the solution; it will likely help somebody in the future. I hadn't run into this one.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    qbee is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    2
    Quote Originally Posted by bbxrider View Post
    ok found it, the workbook name and the sheet name have to be the same for the saved import to work,
    same as here, http://p2p.wrox.com/access-vba/81344...not-found.html. I was copying files with
    a different name to the saved import name, but didn't realize the sheet name had to be an exact match
    as well.
    I am having this same problem. I tried the above solution, but it is not working. I still get the 3709 error.

    Do the Workbook name and the Sheet name have to be identical to each other, or can they be different from each other as long as the same names are used consistently?

    In other words, does it always have to be:

    Workbook Name: FUBAR
    Sheet Name: FUBAR

    -- or can it be --

    Workbook Name: Roses
    Sheet Name: Sunshine

    -- as long as these same names are always used?

    My database is all set to go except for this nonsense.

    Excel is soo not my friend.

    Thanks.

    qbee

Please reply to this thread with any new information or opinions.

Similar Threads

  1. The search key was not found in any record
    By virtualprg in forum Import/Export Data
    Replies: 46
    Last Post: 08-26-2014, 10:51 AM
  2. Search key was not found in any record.
    By mgio in forum Access
    Replies: 2
    Last Post: 08-05-2014, 01:32 PM
  3. Replies: 2
    Last Post: 11-12-2013, 07:06 PM
  4. Replies: 6
    Last Post: 08-22-2013, 08:47 PM
  5. Replies: 8
    Last Post: 04-03-2012, 12:00 PM

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