Thanks for the reply.
Already I tried the search , the issue is the Database is huge wo I don't want get all the data and dump it excel and query it..
Also I am new to sql and macro
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...