The Underscore Archives

>> (50,000 rows). My problem is how do I break the file down? Excel only
>> allows
>> you to open 65, 000 rows at any one time!
>> 
>> Is there any software that I could use for this, or some bizarre
>> method??
>> 

Got a linux box handy ?


split --help

eg 

split ---lines 650000 /my.file

but you should just be able to use mysql's load file stuff.

http://dev.mysql.com/doc/refman/5.0/en/load-data.html


Derek