用ADO.net把Excel文件当作数据源
Public Function CreateConnection(ByVal excelFile As String) As OleDbConnection
baseOleDbConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" & excelFile
Return baseOleDbConnection
End Function
Public Function CreateConnection(ByVal excelFile As String) As OleDbConnection
baseOleDbConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" & excelFile
Return baseOleDbConnection
End Function
