| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
| Querytable range name | Excel Programming | |||
| How to use QueryTable with insertion sql | Excel Programming | |||
| Querytable | Excel Programming | |||
| MS QUERY w/out querytable | Excel Programming | |||
![Rob van Gelder[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
