I need help with the VBA code for Microsoft Access 2002 to do the following:
In a form view, I need to have a command button or list box that will point me to a specific folder on my computer where there will be numerous text files. I need to be able to see these files in this folder from this form, and then I want to choose several files at once for import (TransferText command). I already have my specifications set up for these text file imports.
1) Complete a fully-functional working VBA module with the desired code, which can be exported into my Access database.
2) An explaination of how to set up my form in Access for the multiple text file import.
Microsoft Access XP
Microsoft Visual Basic 6.3