Rietta
Rietta: Web Apps Where Security Matters
You are reading The Rietta Blog, a publication about the web since 2005.

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


About Frank Rietta

Frank Rietta's photo

Frank Rietta is specialized in working with startups, new Internet businesses, and in developing with the Ruby on Rails platform to build scalable businesses. He is a computer scientist with a Masters in Information Security from the College of Computing at the Georgia Institute of Technology. He teaches about security topics and is a contributor to the security chapter of the 7th edition of the "Fundamentals of Database Systems" textbook published by Addison-Wesley.