Error '3709' The search key was not found in any record

[luzz]

Hello everyone, I am facing this error when i use a command button on my form to import the excel file into my access database. How can i solve this??
I realize that i can import the file to my access perfectly fine with file Book113 and i cannot import the file with file Book112. This two file contains similar data, hence i find it so weird why cant i import file Book112.

I have attached my sample database and the excel spreadsheet. Please help me to solve this. Thank you all! Appreciate it alot.

 

[JHB]

It is because the column name " PO Amend No" contain a space as first character.

 

[Pat Hartman]

The table is corrupted. Try compact and repair. Try exporting the data to .csv

 

[luzz]

it is because the column name " po amend no" contain a space as first character.

omg!! Thank you it works now!!

 

[JHB]

You're welcome.