I want to import about 1000 records ( like the 2 below) into excel to sort. What is the most efficient way to to import these to parse / format these records to have one row as a record (vba ?? ) ? I know how to import text files but it doesn't give the formatting options needed for this file. I can provide details, if you need them.


Product Claim
--------------------------------------------------------------------------------
ITEM DETAILS 1 MODEL NUMBER: E34FCGHJR465G
CODE NUMBER: 45657878345342679 NUMBER: 004753Z
MODEL: 3W45 PROD. ATTRIBUTE 3345678346
MODEL YEAR: 2002 PNC DESCRIPTION 456 4567278
PFP DESCRIPTION: MOUNT
CURRENT SERV. LIFE: 15789 MILES
REPAIR DATE: 20060123
PRODUCTION DATE: 20031002
SOLD DATE: 20050307
CLAIM DATE: 20060301
CHARGE PARTS CHARGE VENDOR RATE 0.6
TOTAL CLAIM AMOUNT: 3060 VENDOR AMOUNT: 10.36
CHARGE SPECIAL HANDLING VENDOR RATE 0.6
TOTAL CLAIM AMOUNT: VENDOR AMOUNT:
CHARGE LABOR CHARGE VENDOR RATE 0.6
TOTAL CLAIM AMOUNT: 1275 VENDOR AMOUNT: 4.356
PRR NUMBER: 1 TROUBLE CODE/DESC. NOISE
PRR NUMBER: 2 TROUBLE CODE/DESC. PLAY
HAYON N OUVRE PAS COMPLETEMENT
REMPLACER
REPAIR ACTION#: 1 PART NO: 904507S000
PART QUANTITY: 1 UNIT PRICE: 18.71
REPAIR ACTION#: 2 PART NO: 904517S000
PART QUANTITY: 1 UNIT PRICE: 11.89
REPAIR ACTION#: 3 OPERATION NO: UM14A1
LABOR HOURS: 0.2
TOTAL CHARGEBACK CLAIM AMOUNT: 26.01
RECEIVER CLAIM NO: 015314060
BUSINESS TYPE PRODUCTION PART
STATE CODE NY
ADJSTMNT MEMO NO: 008677465
--------------------------------------------------------------------------------
ITEM DETAILS 2 MODEL NUMBER: BLJALGA327EU5A----
CODE NUMBER: 1N4BA41E34C852439 NUMBER: 118340Z
MODEL: 6ZV2 PROD. ATTRIBUTE 3566892138
MODEL YEAR: 2004 PNC DESCRIPTION 84532 CASING LID TORS BAR/TAIL
PFP DESCRIPTION: LID ASSY-CASING
CURRENT SERV. LIFE: 6464 MILES
REPAIR DATE: 20060216
PRODUCTION DATE: 20030906
SOLD DATE: 20050331
CLAIM DATE: 20060301
CHARGE PARTS CHARGE VENDOR RATE 0.6
TOTAL CLAIM AMOUNT: 690 VENDOR AMOUNT: 4.14
CHARGE SPECIAL HANDLING VENDOR RATE 0.6
TOTAL CLAIM AMOUNT: VENDOR AMOUNT:
CHARGE LABOR CHARGE VENDOR RATE 0.6
TOTAL CLAIM AMOUNT: 1705 VENDOR AMOUNT: 10.23
PRR NUMBER: 3 TROUBLE CODE/DESC. POOR GENERAL APPEARANCE
PRR NUMBER: 4 TROUBLE CODE/DESC. INTERNAL FAILURE
CUSTOMER STATES THE RIGHT REAR CASING SUPPORT HAS COME APART SEE SPECIAL ORDER PART
THE RIGHT REAR CASING STAY IS BROKEN OFF AT THE BOTTOM REPLACED THE RIGHT REAR CASING STA
Y UM14AA 2
REPAIR ACTION#: 4 PART NO: 3566892138
PART QUANTITY: 1 UNIT PRICE: 6.9
REPAIR ACTION#: 5 OPERATION NO: UM14A1
LABOR HOURS: 0.2
TOTAL CHARGEBACK CLAIM AMOUNT: 14.37
RECEIVER CLAIM NO: 015316900
BUSINESS TYPE PRODUCTION PART
STATE CODE MS
ADJSTMNT MEMO NO: 008679905
---------------------------------------