请教，怎么连接Excel文件，读取里面的数据

[fangfangok]

连接字符串怎么写。能不能像操作mdb文件，那样操作xls文件呢

[blackmeit]

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Inetpub\\wwwroot\\contacts.xls;"+
"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet);

[tiantian1024]

Dim sql As String
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strUpFile + ";" + "Extended Properties=Excel 8.0;"
Dim conn As OleDbConnection
conn = New OleDbConnection(strConn)
conn.Open()
Dim schemaTable As DataTable
schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, Nothing)
Dim tableName As String
tableName = schemaTable.Rows(0)(2).ToString().Trim()
sql = "SELECT * FROM [" & tableName & "]"
Dim myCommand As OleDbDataAdapter = New OleDbDataAdapter(sql, conn)
Dim ds As DataSet = New DataSet
myCommand.Fill(ds, "table1")
If ds.Tables("table1").Rows.Count > 0 Then
Dim dt As New DataTable
Dim row As DataRow
dt = ds.Tables("table1")
... ... .
End If

[DNN-2017]

connString = ExcelOperation.GetExcelConnection(ExcelFileName);// 或者"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelFileName + ";Extended Properties=Excel 8.0;"; 

http://blog.csdn.net/jjjjj102310253/archive/2008/11/25/3370346.aspx