Monday, April 02, 2012

New Lines in Cell Data: The SQL Converter Expert Conversion Service Can Handle It!

The SQL Converter Team just had a client whose spreadsheet contained lots of new line characters in individual cell data.  Microsoft Excel 2010 on Windows was removing these new lines when saving the data as CSV or even when attempting to run it through the classic SQL Converter for Excel add-in.

Despite the native Excel limitation, the SQL Converter Expert Conversion Service was able to handle the data and convert it to MySQL 5.  We updated our Ruby-based conversion tool to directly read cell data from an Excel 2010 document and created a SQL dump file that preserved the new line characters within the cell data.

Do you have spreadsheet data that needs to be converted into SQL?  Just send us your spreadsheet and let our professional data conversion specialists do the conversion to SQL for you. Nothing could be easier.  Learn more at:

http://www.sqlconverter.com/expert.html


No comments: