Skip to Content
0
Former Member
Jul 01, 2007 at 11:10 AM

How to add new row and update existing rows at a time form the upload file

13 Views

hi

How to add new row and update existing rows at a time form the upload file

example:ztable(existing table)

bcent smh nsmh valid date

0001112465 7.4 26.06.2007

0001112466 7.5 26.06.2007

000111801 7.6 26.06.2007

1982 7.8 26.06.2007

Flat file structure

bcent nsmh valid date

0001112465 7.8 26.06.2007 ( update into above table in nsmh)

0001112466 7.9 26.06.2007 ( update into above table in nsmh)

000111801 7.6 26.06.2007 ( update into above table in nsmh

1985 11 26.06.2007 new row it should insert in table

thanks,

Sivagopal R