> I have about 25 databases that I need to run the same query against that
> returns about 5 columns of information.
>
> I need this information then published within an Excel spreedsheet.
>
> What is the best way do handle this?
>
> Currently, I'm running each query manually, copying/pasting the result
> to Excel, and repeating...
>
> I need to run this procedure every week, and it takes a considerable
> amount of time.
In that case, I suggest automating it with a small program.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
