Hi,

I have a simple database. It has 3 columns of data and an ID so that I can
sort it into it original order. After having sorted it, I export it as a
text file. Yet every time I export it, there is some portion of the data
which has gotten out of order when I look into the text file, the ID shows
this. How do I stop this happening?

Regs

L

La di da Limey wrote:
> Hi,
>
> I have a simple database. It has 3 columns of data and an ID so that
> I can sort it into it original order. After having sorted it, I
> export it as a text file. Yet every time I export it, there is some
> portion of the data which has gotten out of order when I look into
> the text file, the ID shows this. How do I stop this happening?
>
> Regs
>
> L

Set up a query sorted on the ID and export the data from there. Tables
don't have an order and an ID does not sort the data, it needs to be sorted.
That should do it.

--
Joseph Meehan

Dia 's Muire duit

Hi,

The only problem with that is that it seems to have a limit of 65,000
records and I have 1.5m,

regs,

L


"Joseph Meehan" <(E-Mail Removed)> wrote in message
news:4603d665$0$5782$(E-Mail Removed)...
> La di da Limey wrote:
>> Hi,
>>
>> I have a simple database. It has 3 columns of data and an ID so that
>> I can sort it into it original order. After having sorted it, I
>> export it as a text file. Yet every time I export it, there is some
>> portion of the data which has gotten out of order when I look into
>> the text file, the ID shows this. How do I stop this happening?
>>
>> Regs
>>
>> L
>
> Set up a query sorted on the ID and export the data from there. Tables
> don't have an order and an ID does not sort the data, it needs to be
> sorted. That should do it.
>
> --
> Joseph Meehan
>
> Dia 's Muire duit
>
>
>

On Mar 23, 8:03 am, "La di da Limey" <drbry...@blueyonder.co.uk>
wrote:
> Hi,
>
> The only problem with that is that it seems to have a limit of 65,000
> records and I have 1.5m,
>
> regs,
>
> L
>
> "Joseph Meehan" <sligoNoSPAM...@hotmail.com> wrote in message
>
> news:4603d665$0$5782$(E-Mail Removed)...
>
>
>
> > La di da Limey wrote:
> >> Hi,
>
> >> I have a simple database. It has 3 columns of data and an ID so that
> >> I can sort it into it original order. After having sorted it, I
> >> export it as a text file. Yet every time I export it, there is some
> >> portion of the data which has gotten out of order when I look into
> >> the text file, the ID shows this. How do I stop this happening?
>
> >> Regs
>
> >> L
>
> > Set up a query sorted on the ID and export the data from there. Tables
> > don't have an order and an ID does not sort the data, it needs to be
> > sorted. That should do it.
>
> > --
> > Joseph Meehan
>
> > Dia 's Muire duit- Hide quoted text -
>
> - Show quoted text -

Are you reading it into Excel to look at the order? Excel has a limit
of 65,000 rows. I just exported 2.5m records into a text file -
sorted successfully .

--- Larry Engles

Hi,

No I'm looking at them all in a text editor

L

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Mar 23, 8:03 am, "La di da Limey" <drbry...@blueyonder.co.uk>
> wrote:
>> Hi,
>>
>> The only problem with that is that it seems to have a limit of 65,000
>> records and I have 1.5m,
>>
>> regs,
>>
>> L
>>
>> "Joseph Meehan" <sligoNoSPAM...@hotmail.com> wrote in message
>>
>> news:4603d665$0$5782$(E-Mail Removed)...
>>
>>
>>
>> > La di da Limey wrote:
>> >> Hi,
>>
>> >> I have a simple database. It has 3 columns of data and an ID so that
>> >> I can sort it into it original order. After having sorted it, I
>> >> export it as a text file. Yet every time I export it, there is some
>> >> portion of the data which has gotten out of order when I look into
>> >> the text file, the ID shows this. How do I stop this happening?
>>
>> >> Regs
>>
>> >> L
>>
>> > Set up a query sorted on the ID and export the data from there.
>> > Tables
>> > don't have an order and an ID does not sort the data, it needs to be
>> > sorted. That should do it.
>>
>> > --
>> > Joseph Meehan
>>
>> > Dia 's Muire duit- Hide quoted text -
>>
>> - Show quoted text -
>
> Are you reading it into Excel to look at the order? Excel has a limit
> of 65,000 rows. I just exported 2.5m records into a text file -
> sorted successfully .
>
> --- Larry Engles
>

La di da Limey wrote:
> Hi,
>
> No I'm looking at them all in a text editor
>
> L
>

I have no idea waht that 65,000 limit could be in Access, Older Excel
versions have it but .... ??


--
Joseph Meehan

Dia 's Muire duit

On Fri, 23 Mar 2007 15:03:03 GMT, "La di da Limey" <(E-Mail Removed)>
wrote:

>Hi,
>
>The only problem with that is that it seems to have a limit of 65,000
>records and I have 1.5m,

Please post the SQL of the query and describe how you're exporting it. As
noted elsethread, there is NOT a 65000 (or 65536) record limit to Access
queries or exports, that I've ever seen! What version of Access are you using?

John W. Vinson [MVP]