Home > DeveloperSection > Forums > How to import csv file data in SQL server table?
 Ask Question

How to import csv file data in SQL server table?

Tanuj Kumar

Total Post:134

Points:940

Posted by  Tanuj Kumar
 3215  View(s)
Ratings:
Rate this:
Hello Guys,
I'm facing a problem since last night, please help me! Actually I want to import csv file data in sql server database but I didn't. Could you explain it with code?

Please reply as soon as possible. Thanks in advance!!
  1. Re: How to import csv file data in SQL server table?

    Hi Tanuj Kumar,
    To import data from csv file in SQL Server, you have to use BULK Query Command. Let's take look of Bulk Query Command query.

    Query:  

    BULK INSERT tbl_Name
                   FROM 'csvFileNamewith Path'
                      WITH 
                         (
                            FIELDTERMINATOR = ','
                         )
    I hope it might be resolve your problem.

      Modified On Mar-29-2018 05:08:30 AM

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved

DO YOU WISH TO IMPROVE YOUR BUSINESS ?

Once you’ve signed up as a user for a sponsorship on MindStick network, you will receive sponsored posting opportunities to apply for. It’s a great way to promote your product as a brand.

Yes, help me to improve my business No thanks x