A simple way to import Excel data into a database

Of course, the most rough way is to write your own program to read the Excel program and then inserted into the database, but that way is too high. Say a simple way, the main database management tool support CSV file format data to the table import, and Excel can save the CSV file, this import manual operation is OK, and note that Excel saves the CSV file encoding if it is not the same as the default character encoding of the database table, Can be converted with tools such as notepad++.

Test confirmed lists for most database management tools: MySQL phpmyadmin, SQL Server Enterprise Manager, Oracle's Oracel SQL Developer, PostgreSQL pgadminiii.

A simple way to import Excel data into a database