TranferText Action

[Guest]

I am trying to import several hundred text files into access using a macro
and the TransferText action. How can I tell access that the name of each text
file varies?

 

[Ken Snell [MVP]]

There are various ways to do this... but you don't specify if you want to
tell ACCESS manually by typing in a path/file name, or if you want to use
the Windows OpenFile navigation window, or if you want ACCESS to find the
file names on its own, or what?

Please tell us more details.