BMD4
07-07-2018, 04:03 PM
Hi,
I've created ODBC connection.Now, I need to connect to tables and write data to excel in 3 different sheets (Tab1,Tab2,Tab3).
I have written code to connect to DSN and a sub procedure which has select statements for 3 tables.(select * from tab1..tab2..tab3)
Can any one suggest the code on how to get the output of these queries to excel in 3 tabs
Thanks in advance
I've created ODBC connection.Now, I need to connect to tables and write data to excel in 3 different sheets (Tab1,Tab2,Tab3).
I have written code to connect to DSN and a sub procedure which has select statements for 3 tables.(select * from tab1..tab2..tab3)
Can any one suggest the code on how to get the output of these queries to excel in 3 tabs
Thanks in advance