Data gets out of order when exported

  • Thread starter Thread starter La di da Limey
  • Start date Start date
L

La di da Limey

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 said:
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
Click to expand...

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







- Show quoted text -
Click to expand...

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 said:
Hi,

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

L
Click to expand...

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

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

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]
 
Back
Top