splitting a worksheet

[sandeepmur]

Hi,

I am generating a log stored in .csv format and which has much more than 65,536 rows that an excel sheet permits.

Is there some way I can view all the rows in excel ?? maybe, split the file into number of worksheets ??

thnx for suggestions

 

[gizmo1973]

You could try opening it in Access and then moving less than 65k at a time to Excel.
Other than tht don't know, that's what I ahd to do last time so if someone does know it'd be handy

"Then I’d say what’s the point of having rank if you can’t pull it?"

(DCI Jack Meadows)

 

[baltman]

Google

unxutils head tail

and use head.exe or tail.exe to split your file into <65K lines and then have at it in Excel.

I'd use Access or a data oriented application that doesn't have such a low limit personally, or maybe write the log file with most recent entries at the top so you wouldn't normally have to worry about the bottom.

Brian