Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Text File Data into Excel where records span several row
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data over intranet | Excel Discussion (Misc queries) | |||
Import Text file into Excel and match up records | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) |