On 24 Aug 2004 16:55:41 -0700,
pi********@hotmail.com (Pieter Linden)
wrote:
If this were VB6 or Access, I would create a form with a timer on it
that checked the time every so often and then if the time were
(whatever), run the import. Check www.mvps.org/access for Scheduler
stuff... How to do it in .NET, not a clue.
++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++
thanks to you and david for responses. I believe I've finally solved
the problem in a way similar to your suggestion.
I wrote a macro in the Access db to do 3 things:
1) delete the table
2) import the table again from the specified text file using the
required specification, and
3) quit access
then i created a batch file which opens access and opens the db with
the /x switch and the name of the macro
this will open the db, run the macro, and quit, as per the macro
then i put this batch file in the task scheduler to run shortly after
the daily text report is run.
I had never before realized the full potential of the macros in
Access; now thinking about using it to import to a temporary table and
then munge the data as needed with a query to create an even better
table...one I can use without having to use a query or view on top of
it.
Thanks again,
Larry Rekow
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."