How to import and export data in SQL server from different file format

Total Post:68

Points:476
 1818  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. 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. 

      Modified On Mar-29-2018 05:02:47 AM

Answer