G
Guest
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
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
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
Field Listing as follows.
ItemsSold |SaleNo |Customer |Salesperson|Date|Time|TransactionType
|ProductDescription |Qty| CostExGST |CostIncGST |GST
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
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
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
Field Listing as follows.
ItemsSold |SaleNo |Customer |Salesperson|Date|Time|TransactionType
|ProductDescription |Qty| CostExGST |CostIncGST |GST