Hi All,

I am trying to import a text file into a database and am having difficulties with how the text file is storing the data, example below:

---Text file start---

Name:
Joe Bloggs

Age:
21

Address:
Somewhere

Name:
Bob Builder

Age:
65

Address:
anywhere

---Text file end---

This is how the records are stored, but what i need to do is pull both of these records out of the text file and insert them into an access database. The problem is that when I try standard imports, they do not pick up the field names and import the text file as a single list as it appears in the text file.

Any ideas on how to import this using a tool or with code appreciated.

dagoose