HOW TO IMPORT AND EXPORT DATA IN SQL SERVER FROM DIFFERENT FILE FORMAT

Arun Singh

Total Post:68

Points:476
Posted by  Arun Singh
 1502  View(s)
Ratings:
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!
  1. Pravesh Singh

    Post:412

    Points:2888
    Re: How to import and export data in SQL server from different file format

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!