[ic] Interchange and MySQL

Ed LaFrance edl at newmediaems.com
Tue Nov 18 10:43:44 EST 2003

At 10:46 AM 11/18/2003 -0500, you wrote:
>When I load my products.txt file to MySQL through the IC Admin UI at the
>tables something addeds quotation marks around all the text in the comment
>and size columns. Is this getting done by IC or MySQL? Does any one know how
>to get the files to upload without the quotation marks getting added?

It's not IC or MySQL that is doing this - it's MS Excel. When you export 
and Excel spreadsheet to one of the text file types, Excel double-quotes 
text strings ad nauseum. There is an EXCEL property you can add to database 
definitions that is supposed to counteract this, but I have not used it for 
some time and I'm not sure how it plays with SQL tables:

(near the bottom of the page)

- Ed L.

New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax

More information about the interchange-users mailing list