import a text file in to MS Access table

[iccsi]

I need import a text file in to mt table.
The file format is like following:

Name: MyName Address: MyAddress
Phone: 000-000-000-0000 Birthday: 1900/01/01
Title: My Title Company: My Company

Are there any easy way to do this?
I can read text file and parse the information and import to table or
import in to some kind of table and manage data to have column heading
as field name.

Any suggestion is great appreciated,

 

[Access Developer]

For a file of the structured format you describe (I understand each line to
be a separate record in the text file), I would use VBA and the classic File
IO statements to read the text file, find the data, separate it from the
labels, and store it, then write the record to an Access table when all the
data has been accumulated.

I don't believe the TransferText is quite up to the task, when it is
complicated by having multiple input records for a single Access record and
having the data fields identified by a label in the data itself.