::nod:: I followed that. But please remember that when it comes to CF I am a pretty new newbie and so, uh, when you say "treat it as a double list" are we still in cffile? I need the names of specific commands whose syntax I can look up.
I think I will go this route as I might want to do this in future with the new board also. Dana Andre Turrettini writes: > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5