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??

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??

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