its pretty simple. Just get the data comma or tab delimited, and each line representing one row.
open the file using cffile treat it as a double list. So loop over each row using the chr(13) as the delimiter. then for each row, access each element by its index in the list. trim each piece of data and insert into your db. make sense? DRE > -----Original Message----- > From: Dana Tierney [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 4:14 PM > To: CF-Community > 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 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
