Excel 2003 does not have 150,000 rows......65536 is maximum per worksheet.

Do you want a macro that will import the 150,000 rows?

See this KB article for code to import across several worksheets 65536 rows at a
time.

http://support.microsoft.com/default...;en-us;Q120596


Gord


On Tue, 8 Jan 2008 16:01:00 -0800, Jeff wrote:

I am using excel 2003 so I need a macro.



"Gord Dibben" wrote:

Jeff

Should be easy enough to record a macro whilst doing the sort as you want.

With 150,000 rows I assume version 2007 so I can't help at all with how to
record a macro in that version.


Gord Dibben MS Excel MVP

On Tue, 8 Jan 2008 15:30:00 -0800, Jeff wrote:

Hi,

I am exporting a .csv file from access. Here is the problem, the file is
sorted in access but when it is exported the file is not sorted anymore.

The csv file has 4 columns and 150,000 rows. I want to sort by column 1 and
then column 2. Is there a macro online already created that can do this.

Thanks for your help