I would like to take an SQL query and load it into a dictionary object for use in a for-next loop. I have only seen example of loading the object manually. Has anyone done this? How?
Why don't you use the GetRows function of your recordset which<BR>places all the data in a Variant as a table? After that you can<BR>use the variant containing the table in your for-next loop.<BR>
Thanks I will give this a try. Are there anymore ways of obtaining an array besides writing them manually ?