报错：至少一个参数没有被指定。出错语句是：oleAdapter.Fill(myDataSet, " [sheet1$]"
;我尝试用[sheet]替换 [sheet1$]，又报：数据库引擎找不到对象'sheet'。为什么错误还不一样呢？如何解决？
部分代码如下：
string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + surcce + ";Extended Properties=Excel 8.0";
string query = "SELECT 个体编码,字号名称,经营者姓名,经营地址,经营起始日期,经营截止日期,行业门类,经营范围,监管部门 FROM [sheet1$]";
OleDbCommand oleCommand = new OleDbCommand(query, new OleDbConnection(ConnStr));
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(oleCommand);
DataSet myDataSet = new DataSet();
oleAdapter.Fill(myDataSet, " [sheet1$]"
;
