Hi

Really thankful for the explanation. It makes my day very easy complet all these task. This code was really very much helpful. I dont have words to say thanks...

you need to keep the flat file source in the server not from u r machine or u r machine should act as a server.

Hi will this is helpful for u?

IF OBJECT_ID('temp') IS NOT NULL

DROP TABLE temp

go

CREATE TABLE temp

(

status varchar(20),

state varchar(20),

Name1 varchar(20)

)

insert into temp

select...