PDA

View Full Version : Multiple DSN's for Excel Macro



MacroUser
10-19-2014, 10:42 AM
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 setup the ODBC connection 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

MacroUser
10-20-2014, 08:23 AM
Can somebody please help?