I will convert data in a csv file to SQL Insert statements

convert data in a csv file to SQL Insert statements

About This Gig

I can convert your CSV file containing data into SQL Insert statements for Oracle, MySQL and MSSQL databases. 

What I need from you?
  • The table name.
  • The datatypes of each column (int, varchar etc).
  • The CSV file must have the column headings on the top row and the rest of the rows will contain the data. Example:

Column name 1, Column name 2
Date 1, Data 2

If any field is set to calculate or increment automatically, please leave this out of the spreadsheet as your database tool will do this for you.

Each gig will be for one table only. Please note that I am assuming that the table already exists with primary keys and indexes etc.

What I will deliver?
Text file with a list of insert statements.
Help if the statements do not work

Order Details

Most databases

Most databases will support the output from this gig

1 day delivery