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: 196
mysql
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