CSV Converter
News Download Features Order Contacts FAQ

Convert CSV to SQL

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 conversion

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

Convert CSV to SQL via command line

"c:\Program Files\CSV Converter\csvcnv.exe" file.csv file.dbf [/FILTER|/COLUMNS/|/TYPES|/MYSQL|/ORACLE|/SQL2000]

CSV to MySql conversion

"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.sql /MYSQL

Convert CSV to Oracle

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

Convert CSV to SQL with setting column selection

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

CSV to SQL batch conversion

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

Download Advanced CSV Converter   Buy Now!


Download   Buy Now
See also:
Convert CSV to XML
Convert CSV to SQL
Convert CSV to XLS
Convert CSV to DBF

Copyright © HiBase Group, 2002-2013