Pages

Google Analytics Alternative

Search This Blog

Monday, May 30, 2011

bulk insert into sqlserver using textfile

bulk insert into sqlserver using textfile
Bulk insert sql server 2008 example
I find so many issues while inserting bulk record in database..
Need to create temp table than I has to map all fields which is in file and in table than
Insert it in to actual table but here is one Master command to insert record in bulk through simple statement..
Step 1 ) Create Table.
create table AddressBook (id int,name varchar(50),address varchar(50))
Step 2) Create Text file with “,” delimiter.
1,John,India
2,Raj,India
3,Sonal,India
4,Roshan,India



Step 3) Bulk insert record in to AddressBook table
bulk insert AddressBook
from 'c:\Addressbook.txt'
with
(fieldterminator=',',
rowterminator='\n')





2 comments:

VENKATESU CHOWDAM said...

How about query for bulk delete from text file?

Jayesh L said...

for that you need to go with cursor to execute line by line delete command