import multiline data from text file

[Razorback76]

Hi,
Wondering what the solution would be to importing .txt file data into excel
or access when you are importing data spread over several lines.

Here's a practical scenario

e.g.
1 24582 GENERAL FRED 13/06/06 8:45:08 Sales
~Rounding -1 -0.01 0.01 0.00
BOUQUETS T/T WHT 9pk 1 3.17 3.17 0.00

Sale Total : 3.18 Discount : 0.00

Sale Break Down
Cash : 3.50
Credit Card : 0.00
Other Debtors : 0.00
Customer Account: 0.00
Total Discount : 0.00

2 24583 GENERAL FRED 13/06/06 8:45:56 Sales
KP 24 MEDICATED FOAM 100ML 1 13.59 13.59 0.00
NAPHCON A EYE DRP 15ML 1 1 8.99 8.99 0.00

Sale Total : 22.58 Discount : 0.00

Sale Break Down
Cash : 0.00
Credit Card : 23.94
Other Debtors : 0.00
Customer Account: 0.00
Total Discount : 0.00

Credit Card Break Down
EF 23.94

1 24584 CHRISTOPHER CUSTOMER FAT ALBERT 13/06/06 8:48:21 Sales
~Rounding -1 -0.01 0.01 0.00
ABBOCILLIN-VK FILMTAB TAB 250MG 25 1 12.75 12.75 0.00
PANAFCORTELONE TAB 25MG 30 1 14.50 14.50 0.00
SAPODERM SOAP 3 1 4.54 4.54 0.00

Sale Total : 31.80 Discount : 0.00

Sale Break Down
Cash : 32.25
Credit Card : 0.00
Other Debtors : 0.00
Customer Account: 0.00
Total Discount : 0.00
Customer Account: 0.00
Total Discount : 0.00



Spreadsheet view...
Date | Time |SaleID|TransactionType | Salesperson |ItemDescription |
ItemPrice | ItemsSold


Hope you can help me. A few hours of hair pulling was done on my end.

Cheers

Steve