Hello, i want to clone a database table from one database to another...
i read successfully all contents of the original table to a dataset like this:
then i want to "transfer,clone,copy" the contents of the original table to the destination, can that be done?Code:OdbcCommand cmd; DataSet ds; System.Data.Odbc.OdbcDataAdapter da; string MyString; using (OdbcConnection cn = new OdbcConnection()) { cn.ConnectionString = ("Driver={Microsoft Access Driver (*.mdb)};DBQ="file.mdb";"); ds = new DataSet(); MyString = "select * from Table"; da = new System.Data.Odbc.OdbcDataAdapter(MyString, cn.ConnectionString); cmd = new OdbcCommand(MyString, cn); da.Fill(ds, "Table"); }




Reply With Quote