|
Posted to microsoft.public.excel.misc
|
|
|
Sort .csv file
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
|