Importing a text file into Access Tables

[ewalker3]

I have a text file that has 37 lines in it with two columns of information.
I would like to be able to import certain rows into the table.
The way the file is created it has the would be column names in what would be column 1 instead of on the first row.
a few of the 37 lines has the item name field on one line and on the next the entry for that record.

is there some simple code that can be crafted to easily import these files?

thanks,
ed

 

[Galaxiom]

Show us an example of the text file and what the same data will look like once it is in the table.

 

[ewalker3]

Here is the sample. Some items are on the same line some are on the next line
I want to import source, first/lastname, etc. the content after "notes" I would like in just one text/comment field.

From:
Sent:
To:
Subject: New Lead

Source :
LZ
First
Name :
JON
Last
Name :
SMITH
Phone
Number :
(772) 222-1111
Email :
aaaa
Address
1 :
1313 MOCKINGBIRD LANE
Address
2 :
1313 MOCKINGBIRD LANE
City :
PORT ST LUCIE
State :
FL
Zip :
34444
Case
Notes :
Own Real Estate: Yes | Mortgage Up To Date: No | Own Car: Yes | Car Payments Up To Date: Yes | Employed: Yes | Credit Card Amount: $10,000 - $20,000 | Medical Bills Amount: | Judgements Amount: | Student Loans Amount: | Tax Debts Amount: | Government Fines Amount: | Personal Loans Amount: | Your Pay Period: Every 2 Weeks | Your Net Pay: 525.00 | Spousal Pay Period: | Spouse Net Pay: |