Usually we get data from our client in csv or excel file. So we had to put this value in the database by ourselves. So times inserting data into database requires additional information to check with. This is why we need to generate the sql script with data from csv/excel file. Then we can easily put our required additional checks in the script because data is already in the script. So we can now do what ever we want to do. This project serve the purpose of doing this task easily.

Here is the project directory.


In the above screen shot you will find a csv-upload folder where your generated sql script will be saved. So after running the project if you go to this folder you will find a script generated.

This is the format of the csv file. You need to customize your code according  to your csv.


Here is the sample output of the sql script.

Final Output

Last edited Mar 10, 2013 at 8:14 AM by dpalash23, version 4


No comments yet.