Using Access VBA to Import Files

[troubledloner]

I'm designing an Access application for a client. I would like to make this as easy to use, "point-and-click" as possible. Periodically, the application user will have to repopulate several tables with updated data generated from another application. The datafiles will be text files and will be in a specific format (depending on the datafile). I want to create a Form that will have a drive, directory, and file list box that the user can use to pick the text file to import. How can I do this in Access? I know how to do this in Visual Basic, but not in VBA. I have all of the code written to do the text transfer, but I need to fugure out how to allow the user to pick a file to import.

I've considered doing this using Access commands, but using the "Do Cmd" method allows too much room for user error.

Any hints or replies are appreciated.