I have a program that outputs its calculations as text. It is as follows...
A1 A2 A3 A4 A5
Site 103 Ideal $/Acre Actual $/Acre
N 114.3 37.72 80 26.4
P 37.8 17.75 25 11.75
K 0 0 0.1 0.04
S 0 0 0.1 0.02
Ca 0 0.1
Mg 0 0.1
Cu 0.05 0.01
Zn 0.23 0.23
Mn 0.04 0.01
Fe 0 0.01
B 0 0.01
B1 B2
TAW 9.8 C1 C2 C3
Heat 2928 Ideal Actual
Storage 37 Product 60 56
Density 1.3 Gross 299.97 280.07
pH 7.12 Input 55.47 38.21
EC 0.8 Net 244.5 241.85

As you can see, they essentially have 3 separate tables for 1 record, I labels the column for you with a letter and number.

This is one record, as I log more records for the same site if adds more "record blocks" to the right. If have another site in the file, it creates another row of "record blocks below the first row. I have the data save to a txt file from which Access appends to a table I have created for it. So everytime I work through a site the data overwrites a central file, and access can pull that data into its table.

However, I only need certain data for my access tables A1 and B1 are the names of my fields and the data from A4 and B2, plus the number for "Product" in column C3 which should show up red here.

you can see it isn't always defined to a certain number of records or sites. I have done some manual manipulation of data in the past, but have gotten to the point where it is too time consuming. I am thinking that if access can't sort through this itself, I have an excel file link to it, and have excel do the sorting if possible. However, I am not expereienced enough in excel or access to know how to do this. Below is the list of fields I have in my access table

Site No.
N
P
K
S
Ca
Mg
Cu
Zn
Fe
B
TAW
Heat
Storage
Densite
pH
EC
Product

Unfortunately I can't change the way the program outputs and I am limited to saving as a txt, as far as I know. Anyone have ideas?