I need to regularly move all text files from a directory into a database
(Excel97). All text files are exactly the same number of rows but not in
length of rows and the data within needs to be appended to a single table
(every row is a field in the record). Is there a way to loop through all
..txt files from a directory and run a TransferText that appends the data
from each into the target table?