I have a directory that contains 100+ files (*.txt & *.xls) that I would like to link to an Access database. Ideally I would like link all the files in a subdirectory to tables with names that are the same as the file name without the extension. The files all contain headers in the first row of the file. Additionally, I would like all the fields to be imported as text. Does anyone have some VBA code that would help automate this process?