Hi All,<BR><BR>Following is my req.<BR><BR>I have table T1 is access. Need to push all these contents to a table T2 in sql. (T2 will be initially empty)<BR><BR>The code i have done is<BR><BR>1. populate accDS with contents from t1 (with n rows)<BR>2. execute a select query in t2 and assign to a sqlDS (which will carry 0 records) <BR>3. copy accDS to sqlDS (currently it will carry n rows)<BR>4. call dataadapter.update with sqlDS.<BR><BR>but this doesn&#039;t update the DB although the records are updated in the sqlDS.<BR><BR>any suggestions?<BR><BR>thnks<BR>anu<BR>