Sort .csv file

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

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

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

Excel 2003 only goes up to 65,536 rows so presumably you are using Excel 2007.

In any case, I don't think you would be gaining much by using a macro for a
simple sort, especially if this is a one-time task, or even an occasional
one. If you have to do it over and over again, then a macro might help, but
not by much.

Just select the whole list (all 4 columns and all rows), then Data\Sort\Sort
by A, Then by B, and let it rip.



"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

I DO NOT HAVE EXCEL 2007.

SO THEREFORE I CANNOT SORT A CSV FILE THAT IS 150,000 ROWS

Therefore I need a macro.

Can you help???

"TRYING" wrote:

Excel 2003 only goes up to 65,536 rows so presumably you are using Excel 2007.

In any case, I don't think you would be gaining much by using a macro for a
simple sort, especially if this is a one-time task, or even an occasional
one. If you have to do it over and over again, then a macro might help, but
not by much.

Just select the whole list (all 4 columns and all rows), then Data\Sort\Sort
by A, Then by B, and let it rip.



"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

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

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

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