forum

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?

Anonymous User 3686 24-Mar-2012
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!!
mssql server mssql server 
Updated on 26-Mar-2012
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

26-Mar-2012

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.

Liked By