It looks like you may have it worked out from some of your later posts, but in case this is what I was thinking of:
Description: ACCESSQL allows you to convert Access databases and Excel spreadsheets saved as tab delimited Text(*.txt) to mySQL. Creates and populates tables automatically from the source file. Quick and easy to use. No set up necessary. Just extract and its ready to go. Update: Version 1.1 contains bug fixes and allows delimiter to be changed. http://www.hotscripts.com/Detailed/16571.html > -----Original Message----- > From: Dana Tierney [mailto:[EMAIL PROTECTED] > Sent: 07 June 2003 15:43 > To: CF-Community > Subject: Re: import > > > thanks :) > > Wayne Putterill writes: > > > I quoted on something like this about a year ago, nothing > came of the > > job but I do remember that there were php scripts that > would take text > > files and import them into mysql. Check some of the script > sites out. > > > > > -----Original Message----- > > > From: Dana Tierney [mailto:[EMAIL PROTECTED] > > > Sent: 06 June 2003 19:18 > > > To: CF-Community > > > 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
