>I have an existent text file in the following format
the only available e-form of the data required ....
>================================
>Department: South-East [1]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [2]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [3]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [4]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [5]
>Department: North-West [6]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [7]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [8]
>Department: South-West [9]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [10]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [11]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [12]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [13]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [14]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [15]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [16]
>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [17]
>etc
>================================
>where the XXX AA rows have data relating to the header
>department row.
>
>What I want to be able to do is to get the Department
>as an initial column in the report and put this into a database
>table.

>================================
>South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX [2]
>South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX [3]
>South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX [4]
>South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX [5]
>North-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [7]
>North-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [8]
>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [10]
>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [11]
>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [12]
>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [13]
>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [14]
>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [15]
>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [16]
>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [17]
>etc
>================================

"mountain man" <hobbit@southern_seaweed.com.op> wrote in message
news:OH7pd.47400$K7.40025@news-server.bigpond.net.au...
> In an earlier post I made a fundamental inaccurate typo.
> What I should have said is "initial column" (ie: col001).
>
> Thank you very much to all the responses which were
> helpful, and the article fantastic, as during the successive
> imports of these (sometime large) text files, the order of
> the rows invariably manifested shuffling.
>
> To make a re-specification of the problem, using the row
> numbers as indicated earlier in the article (thanks Steve)
> http://groups.google.com/groups?q=4642ED84B33F
> This article resolved this problem.
>
>>I have an existent text file in the following format
> the only available e-form of the data required ....
>>================================
>>Department: South-East [1]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [2]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [3]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [4]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [5]
>>Department: North-West [6]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [7]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [8]
>>Department: South-West [9]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [10]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [11]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [12]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [13]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [14]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [15]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [16]
>>XXXXX AAAAAAAAAAAAA XXXXXXXXXX [17]
>>etc
>>================================
>>where the XXX AA rows have data relating to the header
>>department row.
>>
>>What I want to be able to do is to get the Department
>>as an initial column in the report and put this into a database
>>table.
>
>
> Show the rows numbers for info only, the end
> result table needs to look like the following:
>>================================
>>South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX [2]
>>South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX [3]
>>South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX [4]
>>South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX [5]
>>North-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [7]
>>North-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [8]
>>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [10]
>>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [11]
>>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [12]
>>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [13]
>>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [14]
>>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [15]
>>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [16]
>>South-West XXXXX AAAAAAAAAAAAA XXXXXXXXXX [17]
>>etc
>>================================
>
> Once again, thanks for the assistance. Sorry about the original
> and fundamental typo (Joe C. picked it up).
>
> Any ideas gratefully received.
>
>
> Pete Brown
> Falls Creek
> Oz
> www.mountainman.com.au
>
>
>