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
*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
*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