DataSet Merge method

[mayankaerry]

Hi,

I am facing an error on calling Datset update method.
Following is my scenario:

There are Three Excel Files Test1.xls,Test2 .xls and Test3.xls.

There is data in Test1.xls as under:

B
1
2
3

The data in Test2.xls is:

B
8
9

The Test3.xls is empty with column
B

Now I created two data sets on Test1.xls and Test2.xls and merged both now I want to insert the data in this data set in Text3.xls. But I am getting error
OledbExcpetion was unhandled.

"Syntax error in INSERT INTO statement."

Following is the code:

string connectionStrin g = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=D:\Siebe l\Test1.xls;Ext ended Properties=""Ex cel 8.0;HDR=YES;""" ;

string connectionStrin g1 = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=D:\Siebe l\Test2.xls;Ext ended Properties=""Ex cel 8.0;HDR=YES;""" ;

string connectionStrin g2 = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=D:\Siebe l\Test3.xls;Ext ended Properties=""Ex cel 8.0;HDR=YES;""" ;

DataSet ds = new DataSet();


DataSet ds1 = new DataSet();


System.Data.Ole Db.OleDbDataAda pter da =
new System.Data.Ole Db.OleDbDataAda pter("SELECT B FROM [Sheet1$]", connectionStrin g);

System.Data.Ole Db.OleDbDataAda pter daDest =
new System.Data.Ole Db.OleDbDataAda pter("SELECT B FROM [Sheet1$]", connectionStrin g1);

System.Data.Ole Db.OleDbDataAda pter da2 =
new System.Data.Ole Db.OleDbDataAda pter("SELECT * FROM [Sheet1$]", connectionStrin g2);

da.AcceptChange sDuringFill = false;

da.Fill(ds);
daDest.Fill(ds1 );

ds.Merge(ds1, true, MissingSchemaAc tion.Ignore);

System.Data.Ole Db.OleDbCommand Builder x = new System.Data.Ole Db.OleDbCommand Builder(da2);

DataSet ds3 = new DataSet();
da2.Fill(ds3);


da2.Update(ds);