Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |