TransferText method -- pass parameterized query?

J

Jeff Norville

I have this pretty big dataset and output 70+ csvs to a charting
program twice a year ... be lovely to loop through the dataset to
output my text files.

Took the approach of creating 1) parameterized query through VBA:

....parameterize query beforehand works fine:
Set qParameterized = CurrentDb.QueryDefs!qryDataset
qParameterized.Parameters![param1] = strParamOne
qParameterized.Parameters![param2] = strParamTwo

Then 2) output the value using TransferText method:
DoCmd.TransferText acExportDelim, , "qryDataset", "C:\DEV\test.csv"

....but since I'm passing the object to DoCmd.TransferText I don't get
to pass the parameters along, apparently.

Insight appreciated, high-centered too early on Monday. Thanks!
 
Top