Re: Importing Excel Data in MySql
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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Importing Excel Data in MySql
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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 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 them...and when we import, of course MySql thinks | the portion between 2 commas for example is a table field... | | What can we do ? We can't control what the client have typed, neither tell | them "Don't use , or ;" neither ckeck and modify every xls file Can you not export to a tab delimited file? You should be able to then import that into MySQL. Or if not, replace the tabs with pipes? - -- /* All outgoing email scanned by AVG Antivirus */ Amer Neely, Softouch Information Services Home of Spam Catcher & North Bay Information Technology Networking Group W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | PHP | MySQL | CGI programming for all data entry forms. "We make web sites work!" -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (MingW32) Comment: For info see http://www.gnupg.org iEYEARECAAYFAkF4b8oACgkQ3RxspxLYVsWQxgCgo+8cAl1icbYRRVPKEDPW98Jd rFQAn0IL9DtKhoOjfV3pyDPGQJzfVHg1 =M04C -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Importing Excel Data in MySql
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 > > > 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 thinks the portion between 2 > commas for example is a table field... > > What can we do ? We can't control what the client have typed, > neither tell them "Don't use , or ;" neither ckeck and modify > every xls file > > Thanks for any idea > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Importing Excel Data in MySql
> 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:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Importing Excel Data in MySql
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 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 course MySql thinks the portion between 2 commas for example is a table field... What can we do ? We can't control what the client have typed, neither tell them "Don't use , or ;" neither ckeck and modify every xls file Thanks for any idea -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Importing 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 course MySql thinks the portion between 2 commas for example is a table field... What can we do ? We can't control what the client have typed, neither tell them "Don't use , or ;" neither ckeck and modify every xls file Thanks for any idea