Tag: excel to mysql

Excel to MySQL using Java

Target Audience: Java Developers, Database Developers What should you know already? Basics of Java, JDBC Excel to MySQL conversion can be done using LOAD DATA INFILE command as I discussed in Excel to MySQL blog. But that command is inadequate when you need to read the excel cell value and making some calculations or concatenations …

Continue reading

Permanent link to this article: https://blog.openshell.in/2011/05/excel-to-mysql-using-java/

Excel to MySQL

Usually MS Excel provides many options to import data from other sources like XML or using data source. Now, the data from excel file has to be exported to a form which MySQL could read and insert into existing relational tables. You can think about .sql file. Usually, MySQL tables can be imported by SQL script (.sql) files. SQL script file contains the DDL and DML queries. But in our case, we need to load the rows of excel file into a table.

Permanent link to this article: https://blog.openshell.in/2011/02/excel-to-mysql/