Dana, Why not use CF to do this? Read the file, pump it into an array [listtoarray()] using Chr(10) as your separator, then loop over each array index and stuff into the DB... I do this all the time with some of my log files that don't fit into a good bulk import format for SQL Server...
HTH, Jeff ----- Original Message ----- From: "Dana Tierney" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Friday, June 06, 2003 12:17 PM Subject: import I didn't get an answer to this on talk, let me try you guys. I have data in a bunch of text files, where fields are delimited by | characters (user data from a Perl bulletin board). I would like to put this data into a mysql database... Surely there is a better way than cut and paste? Dana But I don't make films But if I did they'd have a samurai - Bare Naked Ladies ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
