Are they regular in size and shape? How big are the files?
I would write a simple cf page that reads and inserts, if the totals are reasonable and you didn't needs to do it everyday. If you get stuck, send me a couple lines of the text file and the db structure to pour it in, and I'll jumble it together. Jerry Johnson >>> [EMAIL PROTECTED] 06/06/03 03:17PM >>> 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5