D&C GLug - Home Page

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

Re: [LUG] Splitting

 



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