On Thursday, July 24, 2003, at 11:20 AM, Bill Conlon wrote:
I would try, looping through the files, using <@tokenize> to split data
into fields. Then write (append) as tab separated values to a new file.
Import the new file into excel to see what it looks like. If there's only a couple of problems, it's faster to clean it here. If there's a bunch of problems, elaborate on the tokenizing.
Then take the cleaned up tab separated file directly into mysql (I use Webmin for that purpose).
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
