CSV Converter
News Download Features Order Contacts FAQ

CSV to SQL Conversion

Advanced CSV Converter allows you convert csv files to sql script (MS SQL, Oracle, MySQL, PostgreSQL) from GUI or command line.

1. Select the csv file (or select folder with csv files for batch conversion).
2. Select the output sql file (or select folder for sql files).

csv to sql converter

3. Preview, select options for sorting, filtering data (if necessary)
You can also select/unselect columns, set order for columns.

common options for csv to sql conversion

4. Select options for sql format: SQL Syntax (MS SQL, Oracle, MySQL, PostgreSQL), rows delimiter (if necessary), and click "Finish"

SQL file format options

CSV to SQL conversion via command line

"c:\Program Files (x86)\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)\CSV Converter\csvcnv.exe" sample.csv sample.sql /MYSQL

Convert CSV to Oracle

"c:\Program Files (x86)\CSV Converter\csvcnv.exe" sample.csv out.sql /ORACLE

Convert CSV to PostgreSQL

"c:\Program Files (x86)\CSV Converter\csvcnv.exe" sample.csv out.sql /POSTGRESQL

Convert CSV to SQL with setting column selection

"c:\Program Files (x86)\CSV Converter\csvcnv.exe" sample.csv out.sql /COLUMNS:NAME,CITY,STREET

CSV to SQL batch conversion

"c:\Program Files (x86)\CSV Converter\csvcnv.exe" c:\mybase\*.csv c:\mybase\ /TOSQL /MYSQL

Conversion with command GO

"c:\Program Files (x86)\CSV Converter\csvcnv.exe" c:\mybase\mytable.csv c:\mybase\myscript.sql /go /MYSQL

Conversion to SQL Server

"c:\Program Files (x86)\CSV Converter\csvcnv.exe" sample.csv server.sql /MSSQL

Updated Fri, 10 May 2019

Back to CSV Converter Home

for FREE

See also:
Convert CSV to XML
Convert CSV to XLS
Convert CSV to DBF

Contacts |  Page top | Copyright © HiBase Group, 2002-2019