i only have two condition right now to do insert and update others are related to excel formating thanks

also if i do only insert statement it work like charm. it...

still the same it is not inserting all records. the file has 695 records and i only get 29 with initial setup or 204 after having is null criteria!!

the print statements gets all the records on the result set.

All three are getting value integer( or numbers) from the file.

else

begin

While @test1 != 0 and @test2 != 0 and @test3 != 0

begin

insert into testtable([Filename],fname,testdate,DOM,temp,cast,volume)

values

(@srcFilename,@testname,@PM,(@currentRow-@dataStartRow + 1),@test1,@test2,@test3)

end

end

I tried that but it just goes on and on for ever!!

thanks for reformating.

It needs to go on to end of last insert!!

Thanks

got it working with the adding password = password in connectino.

Thanks

Hi all,

I am getting this error after doing the last step.

the connection string is not valid. it must consist of one or more components of th form X=Y, seperated by...

Hi sorry for the confusion,

I am trying to use SSRS. I tried that logic before but i only colors the whole text box not the value. and it does not...

Hi

I am not familiar with that at all. and yeah there will be more files in future as well.

hi,

Sorry, the column Day of month is the id for student!!

Thanks

it was not generated from DB but hand written and I need to put it in to DB now!!

yes. I will to the header by colum but only need certain informatoin from it. but it is hard for me to get it here is the information that i...

here is the file. Not understanding the way to get the data form this sample file. attached

how can i put it in to SQL now!!

Thanks for thta.. also looking for the Quartile? Don;t know what that means neither the requestor in company?

Thanks

Pat