creating a timed event for table to save to .txt file twice a day

[Alexander Heimann]

I am trying to figure out how to export data out of an access databse
to a .txt file to a specified folder a few times a day.

the problem i have is a co worker would like to utilize some of the
data from the access database in a business objects report. i would
like to set the access database to save to the text file a few minutes
before the business objects report is schedule to run to ensure the
most up to date data is utilized

any ideas?
thanks a bunch
A

[Bradley]

Alexander Heimann wrote:

I am trying to figure out how to export data out of an access databse
to a .txt file to a specified folder a few times a day.

the problem i have is a co worker would like to utilize some of the
data from the access database in a business objects report. i would
like to set the access database to save to the text file a few minutes
before the business objects report is schedule to run to ensure the
most up to date data is utilized

any ideas?
thanks a bunch
A

Perhaps getting the data when the report is run is a better approach?
(or share the same database file?).
--
regards,

Bradley

[Alexander Heimann]

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message news:<qG***************@news-server.bigpond.net.au>...

Alexander Heimann wrote:

I am trying to figure out how to export data out of an access databse
to a .txt file to a specified folder a few times a day.

the problem i have is a co worker would like to utilize some of the
data from the access database in a business objects report. i would
like to set the access database to save to the text file a few minutes
before the business objects report is schedule to run to ensure the
most up to date data is utilized

any ideas?
thanks a bunch
A

Perhaps getting the data when the report is run is a better approach?
(or share the same database file?).

Thanks for the thought bradley, I thought about this route, and I
can't do that in the process currently set up. Has anyone worked with
timed events or batch loads in microsoft access?