Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing data from ODBC automatically?
Greetings,
I have a spreadsheet containing a macro that fills in cells with data fetched from an SQL database via ODBC. How do I get the data to refresh automatically if the source SQL data changes? For example: Someone opens the sheet, the macro fires, and the sheet is filled with data. Then, someone else adds data to the source SQL table, and... I'd like the sheet to update automatically. I guess this would involve a sort of persistent ODBC connection, but I have no idea how to go about this. Thanks for any suggestions! -John --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 11/6/2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing data from ODBC automatically?
John
I think the best you can do is refresh the querytable when the workbook opens, then refresh every x minutes. If nothing has changed, then the workbook won't change and you only lose a little processing time. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "John E.P. Hynes" wrote in message ... Greetings, I have a spreadsheet containing a macro that fills in cells with data fetched from an SQL database via ODBC. How do I get the data to refresh automatically if the source SQL data changes? For example: Someone opens the sheet, the macro fires, and the sheet is filled with data. Then, someone else adds data to the source SQL table, and... I'd like the sheet to update automatically. I guess this would involve a sort of persistent ODBC connection, but I have no idea how to go about this. Thanks for any suggestions! -John --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 11/6/2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing ODBC data on Protected Sheets | Excel Discussion (Misc queries) | |||
Automatically Refreshing Data at 12am | Excel Discussion (Misc queries) | |||
Automatically Refreshing Data at 12am | Excel Worksheet Functions | |||
Automatically Refreshing Data at 12am | Excel Discussion (Misc queries) | |||
Automatically Refreshing Data at 12am | Excel Worksheet Functions |