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
25 databases with the SAME query? Sounds like the database structure
are pretty similar. Perhaps you want to look into merge tables or
unions.
On Aug 16, 2004, at 12:58 PM, David Mohorn wrote:
I have about 25 databases that I need to run the same query against
that
returns about 5 columns of in
append row and save as csv file
}
regards,
Khazret Sapenov
- Original Message -
From: "David Mohorn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 16, 2004 12:58 PM
Subject: Database Stats
>
> I have about 25 databases that I need to run th
> 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
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 E