读取Excel数据？？

Question

string connstr = "Provider=Microsoft.Jet.OleDb.4.0;data source=" + filenameurl + ";Extended Properties='Excel 8.0;IMEX=1'";
  OleDbConnection conn = new OleDbConnection(connstr);
  conn.Open();
  DataSet ds = new DataSet();
  OleDbDataAdapter oleda = new OleDbDataAdapter("select * from [Sheet1$]",conn);
  oleda.Fill(ds, "[Sheet1$]");
  conn.Close();
  return ds;

报错：外部表不是预期的格式。 请问怎么解决啊？

Answer 1

1.检查下所用的连接字符串是否和电脑上安装的OFFICE是否一致，OFFICE2003和OFFICE2007的连接字符串是不一样的

参照

http://hi.baidu.com/lingyu125/blog/item/5d0e8ffa986c766f034f56f4.html

---

http://blog.csdn.net/zx13525079024

Answer 2

链接字符串：

 

http://connectionstrings.com/

---

Best Regards,
Rocky Yue[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.