Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
parameter value query
You can make a querytable using the MS Query tool that reads your data just like you want. Hard code the parameters for now
Using VBA, you can edit the CommandText property of the QueryTable object to modify the criteria, then just refresh it as necessary Another option would be to use ADO. You can read your data directly from the database using a dynamic select statement and use the Range object's CopyFromRecordset method to populate your spreadsheet HTH -Brad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parameter Query | Excel Discussion (Misc queries) | |||
Parameter query in MS Query from Excel | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |