连接Excel字符串怎么写，我怎么写都是在open（）的时候错误

[a208756]

DataSet ds = new DataSet();
string sqlstr = "select * from [sheet1$]";
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + path + ";Extended Properties=Excel8.0";
System.Data.OleDb.OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn);
System.Data.OleDb.OleDbCommandBuilder cmb = new OleDbCommandBuilder(da);
da.Fill(ds, "tb");
this.GridView1.DataSource = ds.Tables["tb"].DefaultView;
this.GridView1.DataBind();
conn.Close();
conn.Dispose();
ds.Dispose();
da.Dispose();

[yumei20001]

你加个捕获异常的语句先看看,有可能是权限的问题

[xiaoqhuang]

添加引用先
using System.Data.OleDb;//不知除了这个还有没别的。
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Path + ";" +
"Extended Properties=Excel 8.0;";

OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();

[lidong6]

http://www.connectionstrings.com

[a208756]

谢谢大家的帮助，找到原因了，是因为在Excel8.0这里，应该是Excel 8.0
少了一个空格