TransferText Macro

[greenapples]

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.

 

[yellow]

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