Also, if you're on CF8, <cfcfloop file="path to file">. Adrian
> -----Original Message----- > From: Bob Imperial [mailto:[email protected]] > Sent: 13 February 2009 15:38 > To: cf-newbie > Subject: looping a text file for an insert? > > > Hi folks, > > I'm working on something that's new for me here and need some help. I > have a tab delimited text file that is sent to me every night and I > would like to automate the process of inserting the contents into a > table I already have set up. I've been importing the file manually into > and access db then using mySQL migration tool to import it into my > table. This text file comes to me the same way each time with the first > row of values being the column names. I don't have clue how to set this > up other than to use > <cffile action="read" file="D:\WebNew\temp\EPARank.txt" > attributes="readonly" variable="epafile" /> to read the contents and > I've played with that and am able to see the contents doing a dump but > I have no idea how to handle the first row or what the syntax would > even look like. Any help would be appreciated. TIA! > > Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4361 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
