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

Nel post news:[email protected]
*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

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 news:[email protected]
> *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
>
>
>