You are reading a single comment by @Dramatic_Hammer and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Dramatic_Hammer
I've (well a colleague) has got some big csv files (approx 4-5GB).
Even though we're running 64bit Office it turns out that Access, Excel and Powerpivot all through a fit when the file is over 2GB and won't import properly.
What's the best option for splitting the files into manageable chunks? Preferably for Windows.
Options that have occurred to me are using Vim (although I'd have to look up the best way of doing that) or importing into SQL and using queries to get manageable chunks. Both of these will involve me having to do it though, is there a simpler option? I'm sure I used to have a csv splitter at some point