Sort not working - very large file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort a file with many columns, it is a 10 M file. If I break
the file in half, I can sort half and then sort the other half, but I cannot
sort the entire file. Is there a limit that messes up sorting that I haven't
found?
 
There may be an issue with RAM. witha file that large.

If you have MS Access I'd recommend that you either import the data into
Access, or use Access to link to the Excle file, and sort within Access. You
won't have any memory limitations there
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting day names chronologically 5
E-mail Sort 2
sorting column with blanks 1
Expand Selection in Auto filter 7
Columns not sorting properly. 2
I want to sort a column of data which is the SUM of three cols 1
sorting with custom data 1
2 dimensional date sort 1

Back
Top