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]
