View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tannu tannu is offline
external usenet poster
 
Posts: 10
Default 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