No, I don't work with the text file in CF. I have a dummy access datasource that I use (cause I don't have to bug the server admins that way). So, I read it into access and the do a query on the access db and loop it and dump each record into Oracle. -d
----- Original Message ----- From: "Dana Tierney" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Friday, June 06, 2003 5:14 PM Subject: Re: import > wait you use CF? using a read command? > > Deanna Schneider writes: > > > 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 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
