View Full Version : Importing from Excel

12-19-2010, 03:02 PM
I want to bring data from certain cells in an Excel workbook into a datatable. The Excel is 97 - 2003 and is in \BoxStore. The code snippet below gives an error "Could not find installable ISAM". From what I see in the literature, this error often means that there is an error in the connection string or thereabouts. I can NOT find the error. I expect it's glaringly obvious, but....

These are the namespaces

Imports System.Data
Imports System.Data.Common
Imports System.Data.OleDb
Imports System.Data.Odbc
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.IO
Imports System.Web
Imports System.Web.HttpResponse
Imports System.Web.UI.HtmlControls
Imports System.Web.UI.WebControls
Imports System.Web.HttpContext

The working snippet is :

ASP.NET Syntax (Toggle Plain Text)

' Create the connection string for the EXCEL file containing the filename and Provider settings.
Dim root As String
root = HttpContext.Current.Server.MapPath("BoxStore")
Dim filepath As String = root & "\" & "Box_zero.xls"
Dim connectionString As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=filepath;ExtendedProperties=""Excel 8.0;HDR=No;""" ' Version A
' Create a new connection object and open it for processing.
Dim objConn As OleDbConnection = New OleDbConnection(connectionString)