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.

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.

"jackle" wrote:

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.

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.

"Kooster" wrote:

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.

"jackle" wrote:

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.

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.

"jackle" wrote:

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.

"Kooster" wrote:

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.

"jackle" wrote:

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.

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.

"Kooster" wrote:

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.

"jackle" wrote:

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.

"Kooster" wrote:

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.

"jackle" wrote:

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.

Here's one:
http://www.businessobjects.com/produ...ts/default.asp

Poke around their site and you'll find more depending on what you want to
do. Note the tight integration with Microsoft, too.

Here's another option: http://www.datawatch.com/index.asp
Look at their Monarch suite.

P.

p.s. If the subset (only the necessary data) to Excel works, I would
probably use it. Let MS-Access be the engine to manage the data, and Excel
perform some of the reporting. You can put some VB over Access to do some
automated routines, too.

"jackle" wrote:

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.

"Kooster" wrote:

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.

"jackle" wrote:

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.

"Kooster" wrote:

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.

"jackle" wrote:

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.