小弟通过Oledb方法访问database,读取,删除、修改excel。
修改总是提示
数据库或对象为只读。
请问各位大侠如何更改数据库或对象属性?谢谢,求指教
String sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\2.xls ;Extended Properties='Excel 12.0;HDR=YES;IMEX=1' ";
//实例化一个Oledbconnection类(实现了IDisposable,要using)
using (OleDbConnection ole_conn = new OleDbConnection(sConnectionString))
{
ole_conn.Open();
using (OleDbCommand ole_cmd = ole_conn.CreateCommand())
{
ole_cmd.CommandText = "CREATE TABLE CustomerInfo ([CustomerID] VarChar,[Customer] VarChar)";
ole_cmd.ExecuteNonQuery();
ole_cmd.CommandText = "insert into CustomerInfo(CustomerID,Customer)values('DJ001','点击科技')";
ole_cmd.ExecuteNonQuery();
}
}