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