Hi Friend ,

Fallow below steps .

1. Create one function with three parameter

String( RowData),Delimeter,Position that return the data for the passed position from the passed rowdata.

Create Function [Functin Name]

(

@Rowdata VARCHAR(8000),

@Delimeter CHAR(1),

@Position INT

)

RETURNS VARCHAR(300)

AS

BEGIN

--Write here code for find the data from the passed Rowdata

END

2. Use bulk insert command and store the data in a #Temp table( Having only one column with size varchar(4000) .

3. After completing above steps in one select statement all the data from the text file will be inserted in your table . For Ex.

Insert into [Table Name]

Select Function(Rowdata,delimeter,position) from #TempTable

Thanks

Vinit Srivastava