List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 17 2001 1:25am
Subject:Re: Load data from text file/Excel worksheet
View as plain text  
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
Load data from text file/Excel worksheetErymuzuan Mustapa17 Jul
  • Re: Load data from text file/Excel worksheetPaul DuBois17 Jul