The search Key was not found in any record

[kevinh2320]

I'm getting the "The search Key was not found in any record" error when trying to run delete queries in my MS Access database. I'm importing data from an Excel file using the following code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "TestTempTbl", _
"C:\Users\UserTest\Documents\MSAccessDatabases\Contracts\Data\ContractData\FY2021ContractsLog.xlsx", False

Any suggestions on how to correct this?

 

[Micron]

Your post is not clear. Are you getting the error when running delete query in Access, or when trying to import? If the latter, make sure no spreadsheet column headers begin with a space, assuming you're using first row as headers.

 

[kevinh2320]

It was while running a delete query. There was a space in the beginning of one of the headers. Thanks for the solution.

 

[Micron]

You're welcome, although I think it was a joint effort!