asp.net
asp.net连接Excel字符串。 问题点数：100、回复次数：6Top
1 楼LaoDai_Net（『老代』）回复于 2005-06-04 16:22:27 得分 5
http://www.connectionstrings.com/
Standard:
"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
OLE DB
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
Top
2 楼renyu732（Sysinfo）回复于 2005-06-04 16:24:58 得分 80
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Inetpub\\wwwroot\\contacts.xls;"+
"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
Top
3 楼renyu732（Sysinfo）回复于 2005-06-04 16:25:25 得分 5
接分。Top
4 楼boytomato（深爱一人叫颖的女孩！）回复于 2005-06-04 16:25:48 得分 10
http://www.yesky.com/20011004/199785.shtmlTop
5 楼teacher1998（英语+asp.net+MsSQL）回复于 2005-06-04 16:28:45 得分 0
推荐本书：app.net200问
要什么有什么，我买了，很好。你的问题上面有的答，可惜我还没看到那！
*_*Top
6 楼aspnet003（aspnet003）回复于 2005-06-04 16:31:30 得分 0
www.connectionstrings.com,全了Top
