none
Import spreadsheet Wizard - The search key was not found in any record RRS feed

  • Question

  • I'm able to import some Spreadsheets; however, when importing a particular file, I get:

    Import spreadsheet Wizard - The search key was not found in any record

    What do I need to do to this particular file so that I can get it imported?

    Thank you, 

    Thursday, July 18, 2019 2:56 PM

All replies

  • hmmm am not familiar with that error off the cuff - - as it sounds like you are using the ribbon's import features then it probably has something to do with the data/file itself...

    if you are importing into an existing table, and that table has a field that is indexed - then possibly that same data field is blank in your spreadsheet....that would be a problem because an indexed field requires a value....

    try a different import such as to its own new table and eyeball that table to see what it looks like ….you're going to have to play around with this one a little...…  you might even consider making temp copies of the spreadsheet and deleting columns while trialing the import to establish which one is the troublemaker....I've been reduced to that on occasion...….

     
    Thursday, July 18, 2019 8:12 PM