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

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

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

Conversion with Saving original date stamp

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

Note: CSV to SQL Converter allows generating the command line and saving it as a .bat file.

Do you need more options for SQL format ?

Please don't hesitate to Contact Us.

Back to CSV Converter Home