I have been trying to write a macro that will automate the transfer of data
from text files into tables in access. So far I have found two ways of doing
it, but neither are exactly what I am looking for.

The first way is to use the sendkeys function to open the get external data
option, but this means that users will have to go through several menus and
this is what I'm trying to avoid.

The other is to use the Transfer text function, but this seems to limit me
to opening one file, I tried to have a text box that users could enter the
file path into, but access doesn't acept this.

Is there any way of importing the data as with the transfer text function,
without having to specify the exact path (maybe just specifying the folder
and bringing up a box that lets the user choose the file they want to import?

Thanks in advance for your help.

Tim