Importing a delimted file that includes the field headings

[Andy13]

I am trying to import a delimited text file. However I am having trouble in
achieveing this as the text string contain the fields that the data needs to
be "attached" to.

The data is formatted so: #Field1#data1#

The data string is shown: #Field1#data1##Field2#data2##Field3#data3# or
#Field1#data1##Field3#data3##Field2#data2#

The data strings string lengths in each line can vary.

As I said how can I import data so that data1 is entered into the column
"Field1" and data2 is entered into the column "field2" etc.

Thanks in advance

 

[Ken Snell [MVP]]

see reply in other newsgroup where you posted this question.