macros to query a database
Hi
Can someone help me with macros to query a database.
Example:
I have a excel sheet with data which i get from querying a database.
query for example:
select host_name,server_vendor,architecture,project,owner from servers
where owner=test123 and architecture='64'
Every time the excel sheet is outdated I have to query a database and
update excel sheet.
So I am lookig for macros which automatically query databse and get
all the information and update the excel sheet.
Appreciate your help.
Thanks
|