Do a basic SELECT * query against the Access table. Loop over the results, doing an insert into the MySQL table for each line.
That's it. Deanna just keeps an Access datasource for this kind of transfer because the interface to Access is easy point-click. You can do the same directly from a text file defined as a datasource. -Kevin > -----Original Message----- > From: Dana Tierney [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 5: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 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
