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, set order for columns.
Step 4: Select options for sql format: SQL 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 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, 10 Oct 2022