need help in MS query from Excel to access

[naren]

I have a database from which i import data to my excel sheet through MS Query (MS Access driver *.db) method where the required two (2) parameters are in cell A2 and B1 with output coming in cell B2.

Now i want to replicate this query to all remaining cells i.e. A2:A1000 and B1:BG1., where A2:A1000 are Dates and B1:BG1 are names. Pivot table is not an option as data is larger than Excel's limits.

So, my question is that,
Is there any way where i can push the required two parameters in my query from a cell A2:A1000 and B2:BG2 in a dynamic way through VBA code or something.
or,
how to pass dynamic parameter linked to a referencing cell so that i can drag and copy same query to different cells without creating individual query for each cells.

Database details::
DBQ=C:\MDB-XL trial\access.MDB;DefaultDir=C:\MDB-XL trial;Driver={Microsoft Access Driver (*.mdb, *.accdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeou t=5;SafeTransactions=0;Threads=3;UID=admin;UserCom mitSync=Yes;

Access Query Details:::
SELECT Quotes.qCl
FROM `C:\MDB-XL trial\access.MDB`.Quotes Quotes
WHERE (Quotes.qTicker=?) AND (Quotes.qDate=?)


thanks in advance for your help ......

 

[naren]

somebody reply.... please.. i am stuck on how to add dynamic reference to the parameters WHERE (Quotes.qTicker=?) AND (Quotes.qDate=?) .....