I have several '.txt' files saved in a folder. I am trying to get a code that upon execution will go through this folder and import all data in the text files into 1 access table. I am working with Access 2010.
Database location: C:\My Documents\ImportData.accdb
Text file locations: C:\My Documents\TextFiles
Text files: Separated by 1 space (no commas) and has no headers. (example attached)
Access table created: ImportedTextData
There will be hundred of text files in this folder. Any help would be appreciated.