Exception in a Query

can anyone tell me why this query throws an error "No value given for one or more required parameters."

Select Status from [Viewer$] WHERE 开发者_StackOverflow中文版 SlNo-Viewer < 4 ... I'm trying to query an excel file and this query is not working with that....Please help....

If SlNo-Viewer is name of a single field, the minus character in the field name is interpreted as the minus operator and it's trying to subtract field called Viewer from field called Slno.

Try this instead:

Select [Status] from [Viewer$] WHERE [SlNo-Viewer] < 4