I get this error message Error.JPG when trying to import everything into one memo field.

As far as the VBA import, I added the msgBox and a string of data was displayed. It displayed the column header names in the text file. It didn't have any of the data from the file only column headers.

Thanks for your help thus far. It can't be too far away if its reading the file. Something just off in the loop portion.