--用openrowset语句来实现.执行如下代码就可以了.insert
OpenRowSet('microsoft.jet.oledb.4.0'
,'Excel 8.0;hdr=yes;database=c:\book1.xls;'
,'select * from [sheet1$]')
select * from sytb
OpenRowSet('microsoft.jet.oledb.4.0'
,'Excel 8.0;hdr=yes;database=c:\book1.xls;'
,'select * from [sheet1$]')
select * from sytb
我想导出数据库中的sytb表中的数据到Book1中
请问怎么实现啊?????????
---企業管理器-》數據庫-》所有工作-》導出->按提示操作
SqlConnection sqlConn1=new SqlConnection( connstr);
sqlConn1.Open();
SqlCommand catCMD = sqlConn1.CreateCommand();
catCMD.CommandText = "insert OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;hdr=yes;database=c:\book1.xls','select * from sytb')";
SqlDataReader myReader = catCMD.ExecuteReader(); Label1.Text=" cheng gong";
sqlConn1.Close();
以上程序编译都没通过
总是提示有语法错误,在SQL语句那,我找了半天也不知道哪错
用sqlcommand就不行呢?
SqlConnection sqlConn1=new SqlConnection( connstr);
sqlConn1.Open();
SqlCommand catCMD = sqlConn1.CreateCommand();
Label1.Text=" cheng gong";
catCMD.CommandText = "select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;HDR=NO;DATABASE=c:\test.xls',sheet1$)";
SqlDataReader myReader = catCMD.ExecuteReader(); sqlConn1.Close();