将sqlserver数据库中的数据直接导入到access数据库中,下面的代码怎么执行了没有反应,
请问高手,有没有其他更好的办法直接将sqlserver数据库中的数据直接导入到access数据库中
我用dtswiz试过,但是要到服务器上操作。SqlDataAdapter sqlAdp = new SqlDataAdapter( "SELECT * FROM T_storehouse" , sconn) ;
OleDbDataAdapter accessAdp = new OleDbDataAdapter( "SELECT * FROM T_storehouse" , aconn) ;OleDbCommandBuilder cb = new OleDbCommandBuilder(accessAdp);
DataSet ds = new DataSet ( ) ;
sqlAdp.Fill(ds,"T_storehouse");
accessAdp.Update(ds,"T_storehouse");
请问高手,有没有其他更好的办法直接将sqlserver数据库中的数据直接导入到access数据库中
我用dtswiz试过,但是要到服务器上操作。SqlDataAdapter sqlAdp = new SqlDataAdapter( "SELECT * FROM T_storehouse" , sconn) ;
OleDbDataAdapter accessAdp = new OleDbDataAdapter( "SELECT * FROM T_storehouse" , aconn) ;OleDbCommandBuilder cb = new OleDbCommandBuilder(accessAdp);
DataSet ds = new DataSet ( ) ;
sqlAdp.Fill(ds,"T_storehouse");
accessAdp.Update(ds,"T_storehouse");
OleDbDataAdapter accessAdp = new OleDbDataAdapter( "SELECT * FROM T_storehouse" , aconn) ;OleDbCommandBuilder cb = new OleDbCommandBuilder(accessAdp);
DataSet ads = new DataSet ( ) ;
DataSet sds = new DataSet ( ) ;sqlAdp.Fill(sds,"T_storehouse");
accessAdp.Fill(ads,"T_storehouse");ads = sds;
accessAdp.Update(ads,"T_storehouse");
---------------
string strMdbPath = @"c:\a.mdb";
SqlConnection conSqlServer = new SqlConnection("...");
SqlCommand cmdExport = new SqlCommand("INSERT INTO OPENROWSET('Microsoft.Jet.OleDb.4.0','" + strMdbPath + "';'admin';'',T_storehouse) SELECT * FROM T_storehouse", conSqlServer);
cmdExport.ExecuteNonQuery();
conSqlServer.Close();
SqlDataAdapter sqlAdp = new SqlDataAdapter( "SELECT * FROM T_storehouse" , sconn) ;
OleDbDataAdapter accessAdp = new OleDbDataAdapter( "SELECT * FROM T_storehouse" , aconn) ;OleDbCommandBuilder cb = new OleDbCommandBuilder(accessAdp);
DataSet ads = new DataSet ( ) ;
DataSet sds = new DataSet ( ) ;sqlAdp.Fill(sds,"T_storehouse");
accessAdp.Fill(ads,"T_storehouse");ads = sds;
accessAdp.Update(ads,"T_storehouse");