Anyone know a tool that will convert a .csv file or an Excel data into a SQL statement file? I found a tool that will convert a .mdb but I want to convert an Excel document or .csv file format.
Any help is grateful!
ljCharlie
MySQL tool to convert .CSV to SQL statement
Moderator: General Moderators
mysqlimport: http://dev.mysql.com/doc/mysql/en/mysqlimport.html
LOAD DATA INFILE sql statement: http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
then you can mysqldump (http://dev.mysql.com/doc/mysql/en/mysqldump.html) it
Why would you need to convert csv to sql statements? What the point of such a conversion if you can directly import csv into your database (I'm pretty sure there are tools for other dbs like mysqlimport for MySQL).
LOAD DATA INFILE sql statement: http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
then you can mysqldump (http://dev.mysql.com/doc/mysql/en/mysqldump.html) it