I have file (test.txt), with about 1,000 fields separated by a comma. Anyone know how I can append this into a one field table, or perhaps convert the comma (,) into an enter return so I can append this into a table?

Note: each line has more than one field, so that is why I just can't do a quick append from type csv, etc. However, each item is separated by the comma.