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

Total Post:68

Points:476
Posted on    February-13-2012 8:31 AM

 MSSQL Server MSSQL Server 
Ratings:


 1 Reply(s)
 1229  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

Points:2881
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