Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to import csv file data in SQL server table?

Anonymous User 4082 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!!

Anonymous User

Other

I am a content writter !

1 Answers

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.

MindStick Training