On Wed, 4 Jul 2001, Sherzod Ruzmetov wrote:
>
> That's what I'd do (assuming there's no other programs available, but aint
> sure). Save the excell spreadsheet as a *.csv file, then load it to mysql with
> LOAD DATA command
Be warned, Excel throws out some stupid looking CSV files. I've had it
generate a CSV where 99% of the files had no quoting, but the one field
that had a ' in it was quoted with "s. I had to re-parse the file with
sed to create one that I could import safely.
--
Sapere aude
My mind not only wanders, it sometimes leaves completely.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php