Importing a delimted file that includes the field headings

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

merging data into consistant row headers with skipped fields 3
Need to create a .NET object that will be serialized into a specific XML format 2
Text File Import 1
TSV Data import 1
Data import or transposing... 2
Import a columnar report text file into access 2003 1
Importing a text file 1
CSV Import Rename Broken? 1

Top