I tried this, however as I was typing this in I noticed that ctr was being declared as itself. Sure enough, when I plugged the code in I got an error saying ctr was not defined. I have been searching around desperately with no luck so far. Any further explanation would be great. FYI, this is my first time working with files as my dataset to put into the database, usually I do this using forms, but with the huge amount of data in these files it just doesn't make sense to sit and enter each record in by hand.
Thanks again for any help! Steve ---------- > 1. Line 1 of the txt file contains what used to be column names from > excel. is there a way to remove line 1 so it stops inserting column > names into my database? Can you create a counter before your loop starts, then increment it as the loop proceeds. <cfset ctr = ctr +1> <cfif ctr NEQ 1> <cfquery blahblah...> </cfif> If the ctr isn't on line 1, run the insert. --------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4