Extracting Data from External Source - Automatically

  • Thread starter Thread starter John C.
  • Start date Start date
J

John C.

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??
 
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
 
To extract data from the database, you can use MS Query (Data>Import
External Data>New Database Query). Once the data in in Excel, you can
set the External Data range to refresh every x minutes (Data>Import
External Data>Data 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.
 
Back
Top