Click here to Skip to main content
Click here to Skip to main content

Inserting Bulk Data in SQL Server from Text file

, 1 Jul 2009
Rate this:
Please Sign up or sign in to vote.
Inserting Bulk Data in SQL Server from Text file
bulkinsert.JPG

Introduction

This article is simple one for inserting bulk data from text file in to sql server by using a simple query. 

Prerequisite 

SQL Server 2005

Description

Actually in my blog, one guy asked me how to insert bulk data’s in to sql server 2005.  When I tried to answer him I just wrote this article. There is a simple query to do this.

Here with I have given the query for creating a sample table and query for inserting bulk data from text file. 

Query

The query for creating table,
CREATE TABLE Employee
(
 FName varchar (100) NOT NULL,
 LName varchar (100) NOT NULL,
 Email varchar (100) NOT NULL
)


//Then we have a text file with the bulk datas like as follows,
 vinoth,kumar,itvinoth83@gmail.com
emp1FName,emp1LName,emp1@company.com
emp2FName,emp2LName,emp2@company.com
emp3FName,emp3LName,emp3@company.com
emp4FName,emp4LName,emp4@company.com
emp5FName,emp5LName,emp5@company.com
emp6FName,emp6LName,emp6@company.com
emp7FName,emp7LName,emp7@company.com
emp8FName,emp8LName,emp8@company.com
emp9FName,emp9LName,emp9@company.com
emp10FName,emp10LName,emp10@company.com
emp11FName,emp11LName,emp11@company.com
emp12FName,emp12LName,emp12@company.com

//Now the query for inserting bulk data is, 
BULK INSERT Employee FROM 'c:\bulktext.txt' WITH (FIELDTERMINATOR = ',')

//Now you can see the data's inserted in table by the select query as follows,

select * from Employee 

Conclusion

Hence we are inserting the bulk data’s in to sql server by using a simple query. The thing is that we need to keep a formatted text file with appropriate data’s to insert.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

S.Vinothkumar
Web Developer
India India
Hi Viewers,

I wish to all. This is Vinoth. This is where I try to condense everything that you need to know about me.
 
Blog:
 
visit my blog
 
Interests:

I'm passionate about a great many things and continually learning about the things that interest me. They are wearable computers, User Interface Design, Artificial life, Industrial music.
 

 

 

Comments and Discussions

 
GeneralMy vote of 1 PinmemberSyed Javed5-Dec-10 1:04 
GeneralMy vote of 1 PinmemberVMykyt16-Jul-09 20:48 
GeneralWhats with the "My Vote is 1" remarks. PinmemberShoki3-Jul-09 2:28 
GeneralYou Can use DTS. Pinmembersuresh suthar1-Jul-09 18:48 
GeneralMy vote of 1 Pinmembersuresh suthar1-Jul-09 18:47 
GeneralMy vote of 1 Pinmemberjaan33us1-Jul-09 7:57 
GeneralMy vote of 1 PinmemberJon Artus1-Jul-09 4:55 
GeneralMy vote of 1 PinmemberNejat1-Jul-09 3:27 
GeneralCheck into fmt files for more options on bulk uploads Pinmembericestatue1-Jul-09 2:30 
QuestionRe: Check into fmt files for more options on bulk uploads Pinmembersearching for solution.....5-May-13 23:28 
AnswerRe: Check into fmt files for more options on bulk uploads Pinmembericestatue7-May-13 3:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140814.1 | Last Updated 1 Jul 2009
Article Copyright 2009 by S.Vinothkumar
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid