[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Splitting

To: list@xxxxxxxxxxxxx
Subject: Re: [LUG] Splitting
From: "Robin Cornelius" <robin.cornelius@xxxxxxxxx>
Date: Tue, 16 May 2006 14:51:16 +0100

On 5/16/06, Neil Stone <neil@xxxxxxxxxxxxxxx> wrote:

I've been approached by one of the guys at work, asking if there is some
way of splitting a .csv file in to smaller chunks...

the file it currently 45+mb

it needs to get in to MS Excel (yeah, i know....) which only takes 65535
rows of data.

Anyone got a little script to split the .csv file in to multiple 65500
line files ?

Depending on the frequency of this event and the data involved, VBA it. you can write a little macro that does the reading of the lines directly from the file and places them in a sheet or multiple sheets or what ever you feel like.

Robin

References:
- [LUG] Splitting
  - From: Neil Stone

Prev by Date: Re: [LUG] Village Broadband
Next by Date: [LUG] Controlling a Sky digibox?
Previous by thread: Re: [LUG] Splitting
Next by thread: Re: [LUG] Splitting
Index(es):
- Date
- Thread