Sorting a csv
Jeff wrote:
Hi,
I have a csv that has around 250,000 rows. I have an excel macro that reads
data from the csv, but it expects the csv to be sorted. So I want to sort
the csv file using excel, (I could sort in access and export but this would
not be automated) I want the process automated.
Since the csv is 250,000 rows I cannot open it in excel and sort, because I
have excel 2003 it has a maximum row of 65,000. Does anyone know how to do
this, I tried looking online but could find nothing.
Thanks
You may be able to sort a csv file using the "sort" command prompt. Type
sort /? at a command prompt for help. Not sure if this will handle
250,000 rows.
Other choice is to upgrade to Excel 2007 or use Quattro Pro, which allow
1,000,000 rows.
Bill
|