I would suggest researching the File System Object for reading a text file line by line. https://stackoverflow.com/questions/...point-vba-code

you can then read the data into a dynamic array (Redim preserve) https://stackoverflow.com/questions/...im-preserve-do

Once you have your data you can determine the fields with a split on the string https://msdn.microsoft.com/en-us/lib...(v=vs.90).aspx

Then loop through your fields and built an SQL insert and execute it (Currentproject.execute SQL) https://www.w3schools.com/sql/sql_insert.asp


Hope this helps!