Multiple DSN's for Excel Macro

[LearningMacro]

Hello All,

I've a excel VBA add-in that fetches the data from SQL server based on user input. When the user enters customercode all the customer data is populated in the spreadsheet.

I've a ODBC connection set up for this macro in ODBCad32.exe.
Now I need to modify my macro to pull data from multiple database using complex join query. Is it possible to get data from multiple database/DSN in Excel Macro? Thanks.

Regards

 

[Deepak]

Welcome to the forum @LearningMacro .

Ya!! that is possible but same might slow down your query.

Check below the ref link.

http://www.vbforums.com/showthread.php?426179-VBA-INSERT-SELECT-query-using-two-different-databases

http://support.microsoft.com/kb/113701