C#的基础问题
我初学C#,现遇到问题,求解,如何将Excel导入Access里面,通过C#实现,我写了代码,不知道哪错了,运行说我有错类型的异常
以下是我的代码,编译通过,没有语法错误。
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=D:\程序代码\ExcelToAccess\zb.mdb";
string SQL = "select * into test from [excel 8.0;database = ExcelRoad],[<sheet1>$]";
OleDbConnection Conn = new OleDbConnection(strConnection);
oleDbCommand1 = new OleDbCommand(SQL,Conn);
da = new OleDbDataAdapter();
da.SelectCommand = oleDbCommand1;
cb = new OleDbCommandBuilder(da);
-------->>>>>这句错了 da.Fill(dataSet1,"test");
dataGrid1.SetDataBinding(dataSet1,"test");