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 and export data in SQL server from different file format

Anonymous User 3018 13 Feb 2012

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 Answers

Pravesh Singh 13 Feb 2012

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.

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.