Can a TransferText Macro be configured to import multiple text files from a given directory? I have over 500 tab delimited text files, all formatted identically, that I would like to consolidate into one Access table.

This post is old so you may have found an answer. You can do it easily in code using a loop.


myfile = dir("c:\The folder containing your files")
do while len(myfile) <>0
Import your file here
myfile = dir()
loop