I have a project that requires me to import about 25 Text files into an access Database and parse out the lines of text using a non-standard field separator. I'm building the code to parse the lines but since there's multiple files I'd like to read in the filenames from the directory and loop through doing all of the files in 1 run of the code. I'm using MS Access 2010. Anybody have any ideas?