Importing Text Mainframe Report

[SKIGAL]

Hello. I have a mainframe report that I have imported into MSAccess. The mainframe report lists the company code at the top of each page with all related records list below. Once imported into Access, the company code is on one line with related records on subsequent lines.

I was wondering if anyone could help me with the code to place the company code in a field for each record of related data. The company code will change numerous times for this file, I just need to know how to get that data from one record to all records below it until the code changes.

Here is an example of the report:

PROGRAM: ACP684 COMPANY PAGE 1
JOBNAME: PAC680 DETAIL RUN DATE: 01/04/2005
JOBSTEP:J010 RUN TIME: 13:45:46
CO-CODE: 0901-
TYPE CHANGE PHONE IXX-NAME DATE IXX-TYPE MONTHLY
XXX XLAKE 1008 CENTRAL 1R $16.00
YYY YLAKE 1010 CENTRAL 1R $16.00

I need the co-code "0901-" in a field in front of each "type" on both of the two records shown. On the next page of the report, the co-code changes.

Thanks for the assistance!!

 

[HitechUser]

How are you importing it into Access? What is the table structure of the import file and your "result" file?

Need some more info..