Re: Load data from text file/Excel worksheet

2001-07-16 Thread Paul DuBois
At 8:19 AM +0800 7/17/01, Erymuzuan Mustapa wrote: > I have an Excel worksheet saved as text file(tab delimited), >Load data works fine on my Win2k(MySQL 3.23.38) for bulk loading but on >MacOS X , MySQL 3.23.39 the same same file doesn't seem to work right, all I >got was malformed data. Usin

Load data from text file/Excel worksheet

2001-07-16 Thread Erymuzuan Mustapa
I have an Excel worksheet saved as text file(tab delimited), Load data works fine on my Win2k(MySQL 3.23.38) for bulk loading but on MacOS X , MySQL 3.23.39 the same same file doesn't seem to work right, all I got was malformed data. Using either LOAD DATA or mysqlimport. If there's a bette