QueryTable OLE DB with Parameter
 

Hi.

Could anyone tell me if it's possible to create an OLEDB QueryTable with one
or more Parameters?

Doing it with ODBC QueryTables are straight forward, yet OLEDB appears
impossible.
I've done a lot of searching and haven't come across anyone with success.

Standard Northwind.mdb using Jet as Provider.

My CommandText: select * from Products where ProductName = ?

VarChar Parameter of Chai

When Refreshing, I get an error:
No value given for one or more required parameters.

Can anyone assist?

Cheers

--
Rob van Gelder - http://www.vangelder.co.nz/excel