Josh Knutson

Pondering Life Away

cffile loop file sql insert

Ohh ok so this was fun, I got to create a page to insert a few hundred thousand records. Since the data was coming from sql 2008 and had to move over to sql 2005. So after generating a file in sql that ended up being about 13 gigs of sql statements. Just in case people need to know you can't actually open files that large in pretty much anything... I ended up downloading LTF Viewer from http://www.swiftgear.com/ltfviewer/features.html

I highly recommend it.

Anyways the code for reading very very large files with cfloop file

1 response to “cffile loop file sql insert”

  1. Make your life more simple get the <a href="http://bestfinance-blog.com/topics/home-loans">home loans</a> and everything you want.

    KinneyKatharine

    KinneyKatharine ~ Sep 14, 2011 at 5:17 AM

Leave this field empty: