Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute a query against an excel doc and a sql server db
I've come across a situation where a customer needs a query executed
against an excel spreadsheet that is auto refreshed and my program's database. I have seen code examples that execute a query against 2 databases but not a database and an excel doc. I've attempted to manipulate the code for 2 databases unsuccessfully. If anyone has any ideas or examples on such a scenario, I would greatly appreciate any help that you can offer. I understand that the use of catalogs and tables in adox is most likely required but I haven't had any luck with it thus far. Rick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute a query against an excel doc and a sql server db
Export the data on the Excel sheet to a table and then use your
methods to access two tables. Excel can export to a variety of different table formats, including CSV, dbf, tab-delimited, etc. Let us know if that helps in some way. -- Jim Carlock http://www.microcosmotalk.com Feel free to post back to the newsgroup! "Rick" wrote in message om... I've come across a situation where a customer needs a query executed against an excel spreadsheet that is auto refreshed and my program's database. I have seen code examples that execute a query against 2 databases but not a database and an excel doc. I've attempted to manipulate the code for 2 databases unsuccessfully. If anyone has any ideas or examples on such a scenario, I would greatly appreciate any help that you can offer. I understand that the use of catalogs and tables in adox is most likely required but I haven't had any luck with it thus far. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel with SQL Query (*.sql) and SQL Server | Excel Discussion (Misc queries) | |||
Query SQL Server from Excel | Excel Discussion (Misc queries) | |||
Query SQL Server from Excel | Excel Worksheet Functions | |||
Excel not finding the server in web query | Excel Discussion (Misc queries) | |||
Use SQL statements in Excel VBA to query SQL Server Data Problem | Excel Worksheet Functions |