Question

I need to insert the data from a csv file which is look something like this
listing_id date available price 0 241032 1 85 1 241032 1 85 2 241032 0 3 241032 0 4 241032 0 5 241032 0 241032 0 7 241032 0 8 241032 0 9 241032 1 85 10 241032 1 85 241032 11 0 12 241032 0 13 241032 0 14 241032 1 85 241032 15 85 16 241032 1 85 241032 17 0 18 241032 0 19 241032 0 20 241032 1 85 21 241032 1 85 22 241032 # 85 - - LO
. into the SQL table which that I've already created . How can i do it?

Answer 1

You can do this using import function of sql server:
the steps to do that are: First create the table in the database
1-Login to database using sql server management studio
2-right click on the database, select tasks and then import data
3-after clicking next, select the flat file source, and import your csv file using browse, configure the data import and then click next
4-For destination select correct database provider, input server name, click on the checkbox use SQL server authentication, input username, password and the database, then click next
5-In select source tables we can edit the mapping then click next
6-Click on the checkbox Run immediately and then click next
Click finish
your data will be uploaded to the table that you created.

Or if you wish to enter the data manually you can use Insert into command in sql query and insert each record in SQL manually.

if you like the answer please provide a thumbs up.