Good morning all,
I am trying to import an Excel file into a datatable. I have run into the Could not find installable ISAM error. I've read a ton of articles on it and they mostly point to the connection string or MDAC. I've verified both. What am I missing?
I am running this on Windows Server 2003 SBE, Service Pack 2. Latest MDAC. Jet version is most recent as well.
My code is listed below. My resulting connection string is
ed Properties="Excel 12.0;HDR=YES;"
Dim strExcelConn As String = ""
Dim strUploadFileName As String = "c:\test.xlsx"
strExcelConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(strUploadFileName) + ";Extended Properties=""Excel 12.0;HDR=YES;"""
Dim dtExcel As New DataTable()
Dim conn As New OleDbConnection(strConn)
conn.Open() ' <-- fails here!
Dim da As New OleDbDataAdapter("select * from [Sheet1$]", conn)
Catch ex As Exception
lblMessages.Text = strConn & "<br/>" & ex.Message