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

Importing Text File Data into Excel where records span several row
 

Nel post
*Razorback76* ha scritto:

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


If (if) I understood your problem, you can simply open the file in Excel
(menu File, Open, in "Files of type" choose Text Files, then select your
file and click Open): the Text Import Wizard will help you in 3 steps...


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Importing Text File Data into Excel where records span several
 

unfortunately it doesn't help.

This is one of those common cases where you have a linked table in a
database with sub-ordinates listed in the same column as applicable. e.g.
Text file appears like the simplified example below...

Heading{Enter}
SubHeading{Enter}
Content {TAB} Value {Enter}
Content {TAB} Value {Enter}
Content {TAB} Value {Enter}

where what you want in the subsequent spreadsheet is .....
Heading | SubHeading | Content | Value |
Heading | SubHeading | Content | Value |
Heading | SubHeading | Content | Value |
Heading | SubHeading | Content | Value |

Conversion to this format ensures a easy transition later to excels Pivot
Tables and the wonderous calculations they can perform etc.

Does that make my problem a little clearer?

Steve




"Franz Verga" wrote:

Nel post
*Razorback76* ha scritto:

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


If (if) I understood your problem, you can simply open the file in Excel
(menu File, Open, in "Files of type" choose Text Files, then select your
file and click Open): the Text Import Wizard will help you in 3 steps...


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy