Import Fixed Width Text File with Header and Detail Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
I want: one Access table listing transaction details and a second Access
table containing the header information.
Click to expand...
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?
 
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 *****
*******************************************
 
Back
Top