transfertext - import into access by selecting from table listing

[kastaman]

Hi there,

On a monthly basis, we import some text files into our database. In order to do this we created a transfertext macro. I'd like a way to import the text files so that we don't need to change the file name in the macro every month, instead I was hoping for a code that will give us a combo-box to determine which files to import.

We have 4 files that we import.



Thanks in advance,

Kastaman

 

[kastaman]

Found the answer after reading through many pages in my search:

thread181-11380



Thanks in advance,

Kastaman