Thanks to all for your suggestions
just have to try all now
Thanks!
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
See http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Hope that helps.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / //
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| We have clients sending us xls file.
| We export them as csv files, using commas or semi-colons. as delimiters and
| then make an import in mysql.
| Problem : some of the fields, containing texts, have sometimes already a
| comma or a semi-colon in th
bertrand
i went to tab delimited fields for the same reason:
commas in text is often done, tabs is rarely done.
david
> -Original Message-
> From: Bertrand Gac [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 21, 2004 12:09 AM
> To: mysql
> Subject: Importing Exce
> You could do a find & replace and change every ; to some other symbol
> directly in excel before importing
I'm not sure our clients will appreciate if I modify their ponctuation
everuwhere :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Excel Data in MySql
Hello
We have clients sending us xls file.
We export them as csv files, using commas or semi-colons. as delimiters and
then make an import in mysql.
Problem : some of the fields, containing texts, have sometimes already a
comma or a semi-colon in them...and when we import, of
Hello
We have clients sending us xls file.
We export them as csv files, using commas or semi-colons. as delimiters and then make
an import in mysql.
Problem : some of the fields, containing texts, have sometimes already a comma or a
semi-colon in them...and when we import, of course MySql thin
