Data gets out of order when exported

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
 
L

La di da Limey

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
 
E

engles

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
 
J

John W. Vinson

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