Glad to hear.

Some confusion lead us to believe you were using Excel 2007.

Your original post stated "when it is exported the file is not sorted anymore"

which to me sounds like you actually got the 150,000 rows into Excel.


Gord

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

Thanks that will help me a lot!!

"Gord Dibben" wrote:

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