Home > DeveloperSection > Forums > How to import and export data in SQL server from different file format
Arun Singh

Total Post:68

Posted on    February-13-2012 8:31 AM

 MSSQL Server MSSQL Server 

 1 Reply(s)
 1208  View(s)
Rate this:
Hello Everyone,
Is there any option in SQL Server to import data from text file.
Please resolve my problem as soon as possible.

Thanks in advance!

Pravesh Singh

Total Post:411

Posted on    February-13-2012 9:10 AM

Hi Arun Singh,
Yes! SQL server has an option to resolve this problem. To import data from text file in SQL table, you can use Bulk Query command. Let's take a look of this command.
BULK INSERT table_Name FROM 'c:\fileName.txt' WITH (FIELDTERMINATOR = ',')

I hope it might be useful for you.

Don't want to miss updates? Please click the below button!

Follow MindStick