Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell value as parameter for VBA access query
Hi,
I have set of values in a worksheet. I have written VBA code for access database connection through ADODB. both excel and access are 2003 version my query will be in a loop, and it takes parameters from the worksheet for each run within the loop. my query looks like: for i=1 to 10 x=sheets(1).range("A"&i) Select * from table1 where id=x; next I was not able to represent the parameter as variable or even as cell reference. only empty recordset is returned. Can anyone help me in this, please... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pass parameter to access query | Links and Linking in Excel | |||
Pivot Table From Access Parameter Query | Excel Programming | |||
Use ADO to retrieve data from Access Parameter Query | Excel Programming | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Pass Parameter to Access Query | Excel Programming |