Hello all; I am trying to extract some information from a report that is in text format (I've attached an example file). I've imported information before from a text file, but for the life of me, I can't remember how I did it. I looked through Access and found the Line Input #1, etc example but I'm not able to kind of use it for my application.
I need to extract several fields of information.
1. For every "Total Number ID=*****" bring that information into an ID field in access.
2. I would need to get the "CASH","Total","Units" under the "Total Number ID" only. ----so it's only the first 2 lines of data under "Total Number ID=*****"
3. Only capture 90 or 91 "CASH","Total","Units" information. This can be found under the "ID=********" field.
So here is what I am aiming to get.
Total Number ID=TI1454
Cash (would be a DB field)
8100.66
6,932,507.08
Total (would be a DB field)
2,368.16
0.00
Units (would be a DB field)
4,344.98
6,918,000.00
If 90 or 91 is found:
90 would be found in this example:
Cash (would be a DB field)
0.00
63.70
Total
0.00
0.00
Thanks in advance for your help.
An example text has been attached.
I need to extract several fields of information.
1. For every "Total Number ID=*****" bring that information into an ID field in access.
2. I would need to get the "CASH","Total","Units" under the "Total Number ID" only. ----so it's only the first 2 lines of data under "Total Number ID=*****"
3. Only capture 90 or 91 "CASH","Total","Units" information. This can be found under the "ID=********" field.
So here is what I am aiming to get.
Total Number ID=TI1454
Cash (would be a DB field)
8100.66
6,932,507.08
Total (would be a DB field)
2,368.16
0.00
Units (would be a DB field)
4,344.98
6,918,000.00
If 90 or 91 is found:
90 would be found in this example:
Cash (would be a DB field)
0.00
63.70
Total
0.00
0.00
Thanks in advance for your help.
An example text has been attached.
