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]