Sure. You can import it into access and then upsize from there. Access lets you use any delimiter you want in the text file. (File - import - external data, follow the prompts from there.)
I do this all the time. and then dump into oracle using CF. It's way easier than getting our DBA to read it in for me. -d ----- Original Message ----- From: "Dana Tierney" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Friday, June 06, 2003 2: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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
