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