CODEWITHSUNDEEP
sqlexcel
NewBie
NewBie

Reputation: 1844

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 SlNo-Viewer < 4 ... I'm trying to query an excel file and this query is not working with that....Please help....

Upvotes: 0

Views: 76

Answers (1)

Shadow Wizard
Shadow Wizard

Reputation: 66388

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

Upvotes: 2

Related Questions