I have hundreds of text files (CSV) that I need to import into Access and export as dbf files. I can do it one at a time, but it's painstakingly slow. I can concatenate all the files into one text file before import, but when I do that I lose the ability to tell what value is associated with what original file (which is important... think of the file names as dates and the data is XYZ positions).
What I would like to do is write a macro that imports all the text files in a directory into separate tables, and exports each as a dbf, preserving the original filenames. Or, imports all the texts files into one table, but adds the attribution of the original file name to each record (so I can query by file name later).
Any thoughts?
Thanks.