I need help with the VBA code that will enable me to import multiple text files into a Microsoft Access database simultaneously. In a form view, I want to be able to see a folder on my computer with the text files, then I want to be able to select several files at once for import (Transfer Text). I already have the specifications I need for the text files.
1) Complete a fully-functional working VBA module that I can import into my Access database.
2) An explaination of how to set up my form.
Windows 2000 Professional
Microsoft Access XP
Visual Basic Editor 6.3