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:
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");
}
then i want to "transfer,clone,copy" the contents of the original table to the destination, can that be done?