Q: "How do I break a large CSV into smaller files?"

A: I've found CSV Splitter (http://tinyurl.com/CSVSplitter) mighty handy--it's a straightforward Windows app that turns a single CSV into multiple child CSVs, giving you the power to determine how long each child CSV should be.  It also preserves the headers in each child file it creates.