SQL Bulk Insert

 

CREATE TABLE TmpStList

(

 stFName varchar (50) NOT NULL,

 stLName varchar (50) NOT NULL,

 stEmail varchar (100) NOT NULL

)

BULK INSERT TmpStList FROM 'D:\mohan.txt' WITH (FIELDTERMINATOR = ',')

Contact

M. Jeyachandran @ M.Jayaramchandran 9840923422 jayaramchandran.m@gmail.com