rkarunmozhi
New Member
Hi:
I established an ODBC connection to SQL database and able to connect from excel 2007. My requirement is to query for few columns from mutiple columns for set of servers
With the Query tool it is time consuming. Is it possible to have a macro or script which will get servername and reslut the needed values from the neeeded columns
Ex:
Enter servername(s): serverA
serverB
Result
ServerName Domain ContactGroup OperatingSystem ProductionType
serverA a.com SA team Unix Dev
serverB b.com DBA team DBA test
I established an ODBC connection to SQL database and able to connect from excel 2007. My requirement is to query for few columns from mutiple columns for set of servers
With the Query tool it is time consuming. Is it possible to have a macro or script which will get servername and reslut the needed values from the neeeded columns
Ex:
Enter servername(s): serverA
serverB
Result
ServerName Domain ContactGroup OperatingSystem ProductionType
serverA a.com SA team Unix Dev
serverB b.com DBA team DBA test