Member Avatar for TKSS

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.