Little poser for any Excel gurus out there . . . .

I have 3 columns in a spreadsheet with over 142,000 values between them.

I need to sort them all as one list, but am restricted by Excels 65,536 row limit

Any idea how best to do it ?

Thanks

 

Use Access !

 

can you past them into a table in access and sort that?
I'm probably missing something important here.

 

Import the Excel table into Access
Open new mdb in Access

File - Get Internal Data - Import Table

 

Oh, and just to add, preferably without using Access

 

Without Access your in trouble me thinks

What about 50,000 approx lines in 3 sheets ????

 

Yeah, thats pretty much how it was originally. But they all need merging. I'll give Access a go but don't use it so may need some pointers . . . .

 

Okay, so the data is imported into a new table as 3 columns. How do I merge them all ?

Copy and Paste Append ?

 

Yeap try it

 

Excellent List merged, sorted and exported again

Cheers for the help.

 

no problem

 

Ar$e. Problem is, I now want to export it to a text file as one list, but it doesn't seem to do all of the records

It keeps ending at the same point. The export doesn't end in error either ?

 

You could try and save as a .csv file
I dont know if these have a qty limit i dont think so ???

 

Just did another check and I think they are all there, but in the wrong order when exported

Do I need to index or anything ? I have sorted the field in ascending order.

Any advice appreciated

 

Highlight all columns in excel
and use DATA tab then SORT
a Window pops up and asks what column you want to use to sort data in

 

Nick, I'm still in Access.

I can sort the results on screen but when I export its not sorted.

I think I have to sort the actual table in Design View ?

 

Oh ok sorry though you were back in excel (dohhh)

Never had that problem before exporting files

It maybe due to the amount of Data you are exporting
I have always kept large files in Access
As you can still do excel style pivots reports in Access

 

Oh well, not to worry, I've got around it now with a bit of major cutting and pasting !

Thanks anyway