Kelly Roper Kelly Roper - 1 year ago 73
MySQL Question

Import Data from Excel Spreadsheet or CVS into 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.

Answer Source

Have a look at LOAD DATA INFILE statement. It will help you to import data from the CSV file into table.