Create a report on moving dbf tables

[kevcri]

I have a job which is run (which I have no control over) which creates several .dbf files, and places them in a folder named after the job number.

I have a MDB which creates reports based on these files. what I currently do is
open the database
drop all the tables
import all the tables (always have the same names, and are in the same folder)
export the report to the folder
then I move on to the next folder and repeat.

I want to make this as automated as possible.
thanks
Kevcri

 

[grnzbra]

A few years ago I worked on a system that did something like this. It had a timer which checked every five minutes to see if it was 5:00 am or after with a flag unchecked. If it found that it was after 5 and the flag had been unchecked (I think it unchecked it around 4:00 am), it would open a link to an ftp site and check to see if there were text files available on that site (the bank that placed the files on the site deleted the existing files around midnight.) If there were no files, it went back to sleep for 5 minutes, after which it would wake up and try again until it found files. At that point it would download the text file to a spot on our computers and then Access would import them using file specs. Finally it would set the flag so that they wouldn't be imported a second time.

I think this kind of processing might be useful in your situation.