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
/ /|_/ / //
I use a tool called navicat. In supports excel imports excellent. They have
a shareware version on their page you can try out.
www.navicat.com
Regards
/Jonas
-Original Message-
From: Bertrand Gac [mailto:[EMAIL PROTECTED]
Sent: den 21 oktober 2004 09:09
To: mysql
Subject: Importing
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