I'm trying to develope a MS Access 97 program that imports data from a text file. I need to the users to select the file from their local drive, but I want to automate importing the data into my table.
I've tried to use both a Macro (Runcommand - Import) and coding (Docmd - TransferText) to do this but both solutions are either too Manually Intensive (user has to navigate through the Import Wizard) or Automated (user can't select the file - the name and location have to be hard coded).
Does anyone have a predefined Form that looks like the "Import" window (a tree view of the local drive along with all the rest of the objects on that specific window) so the user can select the file and directory and then I can assign those values to a variable. That way I can run the Docmd - TransferText code to automate the rest of the import data process.