Import records containing commas into PHPMyAdmin without quotation marks
Posted on 2009-07-16
I'm importing records from a tab delimited file into PHPMyAdmin using PHPMyAdmin's "CSV File Import" tool. However, many of my records contain commas, in which case they're imported with quotation marks. (I suspect this is why the tool has problems importing the records from a CSV file.)
The data is being mastered in Excel and then saved in an Excel-available format (ie. tab delimited, space delimited, space delimited, etc.) Seeking a solution for importing these comma-containing records from an Excel-available format into PHPMyAdmin that doesn't automatically insert the quotation marks. Thanks!