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:4359 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
