CSV to SQL Offline Converter

The SQL format is a native format for many databases, the Structured Query Language. Basically, this is the language most databases use to communicate and to manipulate data. Hence, conversion of CSV to SQL may be required if you need to add data from a CSV file to a database, because direct importing from CSV is not always possible, and even if it is, it may require to overcome certain complexities. On the other hand, SQL script files are open and read by literally any SQL database.

CSV to SQL conversion so never been easy! Advanced CSV Converter allows you convert a single CSV file or folder with 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


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

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.

Updated Fri, 25 Aug 2023

Back to CSV Converter Home