Help on Running Query

J

jackle

I have an Excell spreadsheet (2002) with graphs that I need help on. When I
import (thry a few queries) the data to create the charts every morning, it
takes forever. It is a neccessary evil. is there a way to make a macro to run
at 4am to handle the import via queries and save the file? can this be an
external thing thru the Event Timer in Windows XP? This way it would take a
few moments in the morning to send this within the report.
Any help is greatly appreciated.
 
K

Kooster

Are you pulling the data across a network? Are there any conflicts with the
source database (locking and unlocking of records)? If so, have the source
database send a "subset" or "View Table" to your local machine, then perform
an extraction from the local subset of data.

P.
 
J

jackle

There are not any locking problems. Creating a view is a possibility, but
there are a number of records makes it preferable to have it run the query in
the off hours. there are thousands of records on three different worksheets.
 
K

Kooster

I would use MS-Access as a 'pre-processor' and the database (for thousands of
records) store. You can set the timed events easily in MS-Access to populate
the records with new/changed values; you can use custom VB code if you needed
to suppliment MS-Access routines. You could use a report writer (third-party,
or built-in) to gen the graphs and data in a report. I would not consider
using Excel for this many records.

P.
 
J

jackle

i agree with the access rout. that will be the end result, eventually. the
graphs in access don't lend themseves to editing the points or labels very
well, though. also, there are 3 or 4 graphs/charts on that page. What kind of
3rd party items are you talking about/recommending. E-mailing can get tricky
with access reports. worst case scenerio, export only what is needed to
Excell.
 
Top