| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Queries Against Multiple Databases
I'm currently trying to create stored queries that compare data across tables in different databases on different servers. Is this possible with MSQuery. After a 'fairly' exhaustive search of MS Query help, Excel help, and the Microsoft online KB, I'm not finding anything that is "obvious" on how to make this work. Your assistance is appreciated. Robert Minneman |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Queries Against Multiple Databases
How many databases, how big, how often? If quite
limited you could import them to Excel workseets & write VBA code to do a cell-by-cell comparison. HTH, Merjet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Queries Against Multiple Databases
2 databases, and the data sets can be fairly large.
We don't neccessarily need a comparison between the two databases, but we want to produce a single query that pulls data from both databases into an Excel spreadsheet for reporting purposes. Robert Minneman -----Original Message----- How many databases, how big, how often? If quite limited you could import them to Excel workseets & write VBA code to do a cell-by-cell comparison. HTH, Merjet . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking multiple databases to one summary page | Excel Worksheet Functions | |||
| Can you join multiple databases using a pivot table? | Excel Discussion (Misc queries) | |||
| Importing multiple XML queries into Excel | Excel Discussion (Misc queries) | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| How do I pull multiple queries of external data from the Internet into Excel? | Excel Programming | |||
Linear Mode
