multi text file processing
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
Please don't laugh. I am using MS Access to process text files. Right now it can process one file at a time. I want it to process an entire directory. Following is the current code for selecting the file for processing. can anyone help me modify this to automatically process the entire directory of text files. Function Macro1() On Error GoTo Macro1_Err Dim stringFilename stringFilename = InputBox("Enter the file:") DoCmd.TransferText acImportFixed, "A Import Specification", "A", "c:\data\data1\" + stringFilename + ".txt", False, "" Fred