将excel导入到sql中报错：找不到可安装的 ISAM。 ！！！谁帮帮我啊》？

[hongcha99]

代码如下：
string fullfilename = this.FileUpload1.PostedFile.FileName;
string filename = fullfilename.Substring(fullfilename.LastIndexOf("\\") + 1);
string type=fullfilename.Substring(fullfilename.LastIndexOf(".")+1);
if(type!="xls" || filename!="数据库文件.xls")
{
Jscript.Alert("您选择的文件不正确！");
}
else
{

string mystring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= '" + fullfilename + "';Extended Properties=Excel 8.0";
OleDbConnection cnnxls = new OleDbConnection(mystring);
OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls);
DataSet myDs = new DataSet();
myDa.Fill(myDs);/////////////////////////////////在这里报错！！！！！ 报错：找不到可安装的 ISAM！！

if (myDs.Tables[0].Rows.Count > 0)
{
string strSql = "";
string CnnString = "Provider=SQLOLEDB;database=HSSTORE;server=(local);uid=sa;pwd=wwwwww";
OleDbConnection conn = new OleDbConnection(CnnString);
conn.Open();
OleDbCommand myCmd = null;

for (int i = 0; i < myDs.Tables[0].Rows.Count; i++)
{
strSql = "insert into A(A,B) values ('";
strSql += myDs.Tables[0].Rows[i].ItemArray[1].ToString() + "', '";
strSql += myDs.Tables[0].Rows[i].ItemArray[2].ToString() + "')";

try
{
myCmd = new OleDbCommand(strSql, conn);
myCmd.ExecuteNonQuery();
Jscript.Alert("数据导入成功！");
}
catch
{
Jscript.Alert("数据导入失败！");
}
}
conn.Close();
}

}

[sohighthesky]

连接字符串错误 ，把mystring 打印出来看一下

[hongcha99]

mystring是：Provider=Microsoft.Jet.OLEDB.4.0;Data Source= 'C:\Documents and Settings\Administrator\桌面\数据库文件.xls';Extended Properties=Excel 8.0

[SmallTigerWeskit]

up

[hongcha99]

OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [工作表1]", cnnxls);
DataSet myDs = new DataSet();
myDa.Fill(myDs);


报错：Microsoft Jet 数据库引擎找不到对象'工作表1'。请确定对象是否存在，并正确地写出它的名称和路径

[hongcha99]

好了，结贴

[zhong2006]

string mystring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= '" + fullfilename + "';Extended Properties=Excel 8.0";

去掉单引号；
string mystring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + fullfilename + ";Extended Properties=Excel 8.0";

[xinshengxx]

[Quote=引用 5 楼 的回复:]
好了，结贴
[/Quote]
怎么好的？