Import Fixed Width Text File with Header and Detail Rows

[DevDaniel]

I have: a fixed width text file in the following format
Account 1 header fields
Account 1 list of transactions
Account 2 header fields
Account 2 list of transactions
Account 3 ...

I want: one Access table listing transaction details and a second Access
table containing the header information.

Any suggestions?

 

[KARL DEWEY]

I want: one Access table listing transaction details and a second Access

table containing the header information.

The information needs to be in the same TABLE but different FIELDs.

Is there some disctinct information in a header row? Like maybe the account
numbers?

I have done queries to import similar data but would need to see examples of
the actual data. Can you post a couple of records for several accounts?

 

[DevDaniel]

Hi Karl,

The account number is distinct for each "record".

A simplified version of the data:
*****************************************************
&

DATE: 17-Dec-05 COMPANY NAME TIME: 11:45
STATEMENT PAGE: 1
ACCOUNT: 1000
PERIOD: 16-Dec-05
DESCRIPTION DATE AMOUNT
---------------- ------ ----------
APPLES DEC16 100.50
BANANAS DEC14 25.60
ORANGES DEC12 75.26
***** LAST PAGE *****
&

DATE: 17-Dec-05 COMPANY NAME TIME: 11:45
STATEMENT PAGE: 1
ACCOUNT: 2000
PERIOD: 16-Dec-05
DESCRIPTION DATE AMOUNT
---------------- ------ ----------
POTATOES DEC08 250.78
CARROTS DEC07 16.47
PEAS DEC03 197.24
***** LAST PAGE *****
*******************************************