Tom, you'r very welcome and I'm glad it worked. If you don't mind my
curiosity: If you have thousands of queries to make, does this mean you
will be automating the queries and running the macro in a loop? If so, the
text version should be very good for this since it runs many times faster
than the workbook version. Also, assuming that you will be looping the
program, will the data automatically go to your database?

This is kind of similar to the project I'm working on now for myself,
building a database of stock market fundamental and trading data, using
automated downloads from yahoo, BigCharts, and Wall Street Journal on-line.

Regards,
Shockley

"Tom" wrote in message
...
Ahem! I find it rather engaging <g (or at least addictive!)

:)

It worked, and it is exactly what I needed. Thank you - G'd Bless you
Shockey!!!

I apologize for not providing feedback yesterday. Yesterday in the
evening, I tried the new macro as well as your "&" suggestion, but I
didn't get the output file. However, today I found out what I was
doing wrong, and now everything works!

I got a two week trial password to a database containing economic time
series [i.e. GDP of various countries, etc]. I have a SAS program
that pulls out 1 data series [and it pulls out only observations that
satisfy certain criteria]. However there are literally tens of
thousands of data series that I need to download. I wanted to create
a program containing thousands of small "one time series" programs.
The "technical support" of the university that hosts the database had
refused to help me with this. I will now be able to do it.


All the Best


Tom