Unanswered: Importing multiple text files in to Access (Module)
I wanted to use the "module/ macro" feature for importing multiple files into MS Access. I have several text files all in the same format (and same delimiters) without header rows. I could save all these files in to their own Folder.
Could someone guide me here? Please let me know if you need more details.
Thanks! This works well. Just a small question - I get a number of Import errors (all the same for "Type Conversion Failure").
Essentially, I get one large table with the same import errors and all the files appended to the large table. I've figured out a way to have individual txt files as different tables in Access, since each txt file has multiple records and multiple fields.
Should I be concerned with these errors? I do not want to miss out on any of the records within each txt file.