|
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).
3. Preview, select options for sorting, filtering data (if necessary)
You can also select/unselect columns, set order for columns.
4. Select options for sql format: SQL Syntax (MS SQL, Oracle, MySQL, PostgreSQL), rows delimiter (if necessary), and click "Finish"
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!
|