Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
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

forum

home / developersection / forums / how to import and export data in sql server from different file format
Ask Question

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

Anonymous User 2913 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!
mssql server mssql server
Updated 13 Feb 2012
Anonymous User
Anonymous User

Other

I am a content writter !

Message

1 Answers

Pravesh Singh
Pravesh Singh 13 Feb 2012
Report Abuse
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