Import Data from Excel Spreadsheet or CVS into MySQL

Posted by Kelly Roper on Stack Overflow See other posts from Stack Overflow or by Kelly Roper
Published on 2011-11-06T23:21:20Z Indexed on 2012/12/02 23:05 UTC
Read the original article Hit count: 191

Filed under:

I have a spreadsheet which really has only one complicated table. I basically convert the spreadsheet to a cvs and use a groovy script to generate the INSERT scripts.

However, I cannot do this with a table that has 28 fields with data within some of the fields on the spreadsheet that make importing into the CVS even more complicated. So the fields in the new CVS are not differentiated properly or my script has not accounted for it.

Does anyone have any suggestions on a better approach to do this? Thanks.

© Stack Overflow or respective owner

Related posts about mysql