I need help here. I work with a billing system (server), which generates a T file every hour. It names the files sequentially in the format yyyymmddhh. For example, A2002110100, A2002110101, A2002110102 are the first three files generated on November 1, 2002. Every 24 hours, I manually copy all these files to my computer over the network, load DOS and convert and rename them to a single text file before automatically importing it to my Access database.
The DOS command I use to convert, rename and compact to a single text file (say for all files generated on November 1) is as follows:
For %1 in (A20021101*.T) do type %1 >> MyNewFileName.txt
What I want to do now is automate the whole process. On the click of a button, my database should copy all the files generated on the previous day to my computer and then execute the DOS command to convert them all to a single text file.
Any suggestions would be appreciated
The DOS command I use to convert, rename and compact to a single text file (say for all files generated on November 1) is as follows:
For %1 in (A20021101*.T) do type %1 >> MyNewFileName.txt
What I want to do now is automate the whole process. On the click of a button, my database should copy all the files generated on the previous day to my computer and then execute the DOS command to convert them all to a single text file.
Any suggestions would be appreciated
