We have several very large CSV text files (550+ MEGS). These files are
to be imported into ACT! contact management software. How can they be
broken into smaller bite size pieces for editing with with excel or
word?

Hello ketones,

Great question!


You can use what is referred to as a file splitter, to split the files
into smaller, more manageable chunks. Typically you would want one
that does not break the file structure (end of lines), so it is still
usable.

-------------------------------------------------------------------------------

A freeware one, with a specific mention of excel use:

TextCleaver
http://www.bartdart.com/download.php

-------------------------------------------------------------------------------

This one allows you to set a template for splitting and is Free:

SplitFile
http://www.spadixbd.com/freetools/jsplit.htm

-------------------------------------------------------------------------------

Here is one that costs $15.00 to register:

Kaboom File Splitter
http://www.kaboom.org.uk/magic/text.html

-------------------------------------------------------------------------------

Here is a command line utility if you prefer this method:

Filesplit
http://www.pikeus.freeserve.co.uk/junk/filesplit.html


I was also able to locate quite a few free ones for you to try out.
Some of these may break the files mid-data. Most leave the original
file alone and make a copy, then break it up, so you have nothing to
lose by trying them. Just be sure to read the instructions for each :

GSPLIT
"Split large files (normally bigger than 2 GB)."
http://www.gdgsoft.com/gsplit/index.asp

JASP (click on #2 link at site)
"Just Drag the File to be Split onto the JASP window to split the
file!"
http://www.codebytes.net/

Splitty
"Lets you easily verify data integrity in split files"
http://www.basta.com/ProdSplitty.htm



Here is a page that lists a very large amount of these types of
programs :

Nonags Software Repository
http://www.nonags.com/nonags/filesplit.html



To assist with this answer I searched Google for:

text file splitter
://www.google.com/search?q=text+file+splitter


I hope this gives you enough leads to get you started! Please do not
hesitate to ask for clarification should you need it. I would love to
be of further help.


Thanks,
SgtCory

Quick, concise, accurate.