Error "Too few parameters Expected 1" when insert Excel cell value

[dhlao]

I've attach the Excal and Access files.
Just place the Excel file at "C:\", then click the button in the Access form.
It suppose to run the SQL which copy the cell value from Excel file to the created Access table.
It works if the cell value are number. But will show "Too few parameters Expected 1" if the cell value are text string.
Don't understand why

Note that the Excel and Access files were created by Office 2013 64bit

 

[JHB]

Text values need to be surrounded by ' = single quotes!

 

[dhlao]

JHB. Thanks a lot.

This's really a silly mistake :banghead: