CSV to SQL Converter: Generate SQL Scripts from CSV
Advanced CSV Converter turns CSV files into SQL scripts for MS SQL Server, MySQL, Oracle and PostgreSQL: INSERT statements and CREATE TABLE commands, one file or a whole folder at once. Works offline, from the interface or the command line.
Step 1: Select the CSV file (or select folder with csv files for batch conversion).
Step 2: Select the output SQL file (or select folder for .sql files).
Step 3: Preview, select options for sorting, filtering data (if necessary)
You can also select/unselect columns for CSV to SQL conversion, set order for columns.
Step 4: Select options: Syntax (MS SQL, Oracle, MySQL, PostgreSQL), rows delimiter (if necessary), and click "Finish"
CSV to SQL Command Line
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" file.csv script.sql [/FILTER | /WFILTER | /COLUMNS | /TYPES | /MYSQL | /ORACLE | /MSSQL | /POSTGRESQL | /NOCREATETABLE | /GO]
CSV to MySQL conversion
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" sample.csv sample.sql /MYSQL
Convert CSV to Oracle
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" sample.csv out.sql /ORACLE
Convert CSV to PostgreSQL
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" sample.csv out.sql /POSTGRESQL
Conversion with setting column selection
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" sample.csv out.sql
/COLUMNS:NAME,CITY,STREET
/COLUMNS:NAME,CITY,STREET
Batch conversion (Folder to Folder)
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" c:\mybase\*.csv c:\mybase\ /TOSQL /MYSQL
Inserting the command "GO"
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" c:\mybase\mytable.csv c:\mybase\myscript.sql
/go:200 /MYSQL
/go:200 /MYSQL
Conversion to MS SQL Server
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" sample.csv server.sql /MSSQL
Using the Wide Filter
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" c:\mybase\*.csv c:\mybase\ /TOSQL /MYSQL
/WFILTER:Canada
/WFILTER:Canada
Conversion with Saving original date stamp
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" c:\mybase\*.csv c:\mybase\ /TOSQL /MYSQL
/KEEPDATE
/KEEPDATE
Generate only "CREATE TABLE" commands
"c:\Program Files (x86)\Advanced CSV Converter\csvcnv.exe" c:\mybase\*.csv c:\mybase\ /TOSQL /ANALYZE
/MYSQL /CREATEONLY
/MYSQL /CREATEONLY
Note: CSV to SQL Converter allows generating the command line and saving it as a .bat file.
Do you need more Command Line Options ?
Please don't hesitate to Contact Us.
Frequently Asked Questions
Which SQL databases are supported?
MS SQL Server, MySQL, Oracle and PostgreSQL.
Can I convert a folder of CSV files at once?
Yes. See the "Batch conversion (Folder to Folder)" example above.
Can I add the GO command for SQL Server?
Yes. See the "Inserting the command GO" example above.
Are my files uploaded anywhere during conversion?
No. Conversion runs locally on your computer.