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. Using either LOAD DATA or mysqlimport.
The file may not be the same on both systems. Perhaps the line endings
have changed, for example. What does your LOAD DATA statement look like?
If you're using LINES TERMINATED BY '\r\n' try LINES TERMINATED BY '\r'
instead and see if that works.
>If there's a better way for me to accomplish this? If not then could someone
>help me out with this instead.
>Thanks in advance
Paul DuBois, paul@stripped