I want to take information from one database and save it in another database. how can i change the direction of the data adapters? I have also tried to define new data adapters in the same way as the others but with the connection string fixed to the target database, but this make nothing.
The structure of the tables in both database is the same, the target database is only a subset of the another one.
I have also changed the connection string and i hoped it to work but still doesn´t work; the code is as folow:


Code:
daProjekteure = New OleDb.OleDbDataAdapter(strConnection(2), connection) 
daProjekteure.Fill(dsPav, "tbProjekteure") 
.......... 
Dim cmdbuilder As New OleDb.OleDbCommandBuilder(daProjekteure) 
connection.Close() 
connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strWrapper 
connection.Open() 
daProjekteure.UpdateCommand = cmdbuilder.GetUpdateCommand 
daProjekteure.Update(dsPav, "tbProjekteure") 
............
I think i have to changed the "Rowstate" prperty to "Added" but i am not sure and this property is onlyRead property.

Can anyone help me?
Thanks
Álvaro