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
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
/ /|_/ / //
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
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
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:
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 Excel Data in MySql
-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