Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Data from External Source - Automatically
I would like to extract data that is contained in a
database. I want this extraction to be automated, every 10-minutes, and also allow the user to push a command button to ensure all data is current. This information will in turn be used to update a trend graph for the parameters extracted. Where do I begin?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Data from External Source - Automatically
I suppose one way is to create a couple of routines. The primary one would
be the macro that connects and retrieves the data from your database. Then you would need one that uses the ontime method that loops every 10 minutes and runs the primary macro. The other would be button_click event for your button that runs the primary macro. The ontime and click macros should be very simple, the primary one may take slightly more effort Paul D "John C." wrote in message ... I would like to extract data that is contained in a database. I want this extraction to be automated, every 10-minutes, and also allow the user to push a command button to ensure all data is current. This information will in turn be used to update a trend graph for the parameters extracted. Where do I begin?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Data from External Source - Automatically
To extract data from the database, you can use MS Query (DataImport
External DataNew Database Query). Once the data in in Excel, you can set the External Data range to refresh every x minutes (DataImport External DataData Range Properties). The External Data Range toolbar that appears when you select a cell in the range has a refresh button that users could click to manually refresh the data. John C. wrote: I would like to extract data that is contained in a database. I want this extraction to be automated, every 10-minutes, and also allow the user to push a command button to ensure all data is current. This information will in turn be used to update a trend graph for the parameters extracted. Where do I begin?? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove an external data source | New Users to Excel | |||
External data source | Excel Discussion (Misc queries) | |||
Need some help in re-organising data from external source | Excel Worksheet Functions | |||
UNC for external data source | Excel Discussion (Misc queries) | |||
Extracting source data that I want | Excel Discussion (Misc queries) |