I am importing an Excel list of names and addresses into Access 2007. Very straighforward but in Access I keep getting an error messages that the search key could not be found in any record. I'm using 1 to 1237 in column A in Excel, then name, address, town state, zip. I did something similar to this the other day and they imported perfectly. Very frustrating because the help functions does not address the search key error. Thanks for any help.