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.

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).

csv to sql converter

Step 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

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

SQL file format options

DOWNLOAD for FREE

CSV to SQL via 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

Convert CSV to SQL with setting column selection

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

CSV to SQL batch conversion

"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 /MYSQL

Conversion to SQL Server

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

Do you need more options for SQL format ?

Please don't hesitate to Contact Us.

DOWNLOAD for FREE
Updated Tue, 27 Jul 2021

Back to CSV Converter Home