Use this tool to convert CSV to SQL statements.


What can this tool do?

  • INSERT, UPDATE, DELETE, MERGE, and SELECT statements can be created.
  • CREATE TABLE, DROP TABLE, CREATE VIEW, DROP VIEW are optional.
  • The key used in UPDATE, DELETE, and MERGE is specified by setting the key column.
  • New Now it is easy to merge csv into a database table by using the new Generate MERGE feature.
  • A field value may be trimmed, made uppercase, or lowercase. You can add custom text around the field value by using the template feature. For example, if you are using Oracle and want to convert a field in YYYYMMDD format to DATE, use TO_DATE({f},'YYYYMMDD'). Likewise for Sql Server, use CAST({f} AS DATETIME). The field value will be substituted for {f}.
  • Current version supports some database specific output and support ORACLE, MYSQL, SQL SERVER, PostreSQL and ANSI SQL databases. There are slight variations in the way different databases handle NULLs, empty strings, DATES, etc. .

What are my options?


  • You can specify which fields to include and specify the name of the field.
  • You can choose to to quote your column names as appropriate for your database engine.
  • See also SQL to CSV
  • You can sort the output by column name.
  • You can use NULL for empty fields.


NEW -You can now Save the complete data and settings, and then later Load them from your saved file.
 

Step 1: Select your input

Option 1 - Choose a CSV file
Option 2 - Enter an URL
Option 3 - paste into Text Box below


 
 

Step 2: Choose input options (optional)


Input Options
  

Field Separator:




Step 3: Choose output options


Output Options Filter records in CSV (click "Add condition" below)
 

Sort CSV  
 Field #TypeDirection
First By
Then By
Then By

NOTE - you can change the column names below by overwriting the Field Name value.
   


 
 

For INSERT (REPLACE INTO tablename ....)

(INSERT phrase INTO ...)
For SELECT and MERGE
Valid if not creating VIEW for SELECT
  NULL value:

Step 4: Generate output


.sql
Blue Hosting