I can't tell you how to combine these results into one long list but you
can use MS query to link an Excel worksheet (through an ODBC or OLEDB
driver) to a database. After you set up all of your links (each link is
database-specific and requires a query from you), all you would have to do
is to refresh your datasets and it would re-run the queries and update
your spreadsheet (all 25 of them). Then, you can copy the values (not the
formulas) from one book to another for a static record. If you copied the
formulas too, you may get the data links which could cause problems in the
future (I am not sure, though , it has been a while. Maybe Excel handles
that better now).
It may not be able to give you the data all in one long set but at least
it automates the process of getting it into Excel.... I would give you
more details but it has been several years since I last set up a workbook
like this and I am afraid that I would be less than useful.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"David Mohorn" <dm4714@stripped> wrote on 08/16/2004 12:58:53 PM:
>
> 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.
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
