The search key was not found in any record - Error when importing source data
Results 1 to 2 of 2

Thread: The search key was not found in any record - Error when importing source data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2011
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default The search key was not found in any record - Error when importing source data

    Here's what I've tried already:

    - CSV file conversion
    - No leading or trailing spaces in column names
    - No non-printable characters in column name

    One observation notice, when the column headers row is completed deleted, the import WORK!
    Adding a column header one-at-a-time is cumbersome because there's like 120 columns.

    Anything you can suggest?

  2. #2
    Board Regular ranman256's Avatar
    Join Date
    Jun 2014
    Location
    Kentucky
    Posts
    1,774
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: The search key was not found in any record - Error when importing source data

    save the current file to a 'generic' file, File2Import.txt
    attach the file as a table. (it will assign all fields as field1, field2, etc)
    build an append query using this table to add it to your target table.
    in the query assign all fields where to append to.
    put this query in a macro.

    so the steps would be:
    1. save the next text file and overwrite the File2Import.txt file
    2. run import query.
    done.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •