•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 426,333 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,413 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1364 | Replies: 0
 |
•
•
Join Date: Jan 2004
Location: VA, USA
Posts: 459
Reputation: 
Rep Power: 6
Solved Threads: 17
Posting Pro in Training
Can this be done? Hi all,
I'm importing external data into Microsoft Excel XP from a database. Not wanting to query all 70 databases we have I'm thinking a macro or some visual basic would work nicely to automate this. However, I'm stuck because everything I read tells me that one cannot query multiple servers at once. Can you connect to multiple servers at once using the "get external data" wizard in excel?
If not, we move on to trying to access all 70 databases one after the other.
Currently, my query works by pulling the data and then creating a new worksheet to display the data. I'd like this to create a new sheet for each database and display the data.
Then the question becomes, how does one automate this so that excel chooses the next DNS ODBC connection in its list? Does anyone know if this can be done?
I'm importing external data into Microsoft Excel XP from a database. Not wanting to query all 70 databases we have I'm thinking a macro or some visual basic would work nicely to automate this. However, I'm stuck because everything I read tells me that one cannot query multiple servers at once. Can you connect to multiple servers at once using the "get external data" wizard in excel?
If not, we move on to trying to access all 70 databases one after the other.
Currently, my query works by pulling the data and then creating a new worksheet to display the data. I'd like this to create a new sheet for each database and display the data.
Then the question becomes, how does one automate this so that excel chooses the next DNS ODBC connection in its list? Does anyone know if this can be done?
My Home Away from Home: Yet Another Linux Blog
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Previous Thread: Opening Outlook Template from Access
- Next Thread: Database Synchronization
