1 Reply Latest reply: May 15, 2014 9:56 AM by RalphB _ RSS

    Open all text files in a folder using VBA

    Metz _

      I'm using VBA in access 97 to dump reports in to another access database. Is there a way to use a wildcard to open all of the text files in the specified folder?


      The file names change daily, are named "F[i]mmdd[/i].TXT, and are deleted after processing. Also, on Monday, I process the files from the weekend, so there are 3 files.


      Any easy way to do this?