I have been trying to import from an Excel file and insert it into a table.
I can upload the Excel file
I can view the Excel file in a grid
But when I run the import process to insert the rows in the Excel file I get only one row and it has all nulls except the dateentered and entered by field.
I added breakpoints and tried setting a couple of the fields to labels and I could see that data was getting to the reader.
So now I hoping someone might see something I'm missing here.
Protected Function ExcelConnection() As OleDbCommand
' Connect to the Excel Spreadsheet (online) = .ACE.OLEDB.12.0 (local) = .Jet.OLEDB.4.0
Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("~/Import_Process/ExcelImport_vol.xls") & ";" & _
"Extended Properties=Excel 8.0;" 'HDR=NO;IMEX=1"
' create your excel connection object using the connection string
Dim objXConn As New OleDbConnection(xConnStr)
' use a SQL Select command to retrieve the data from the Excel Spreadsheet
' the "table name" is the name of the worksheet within the spreadsheet
' in this case
View Complete Post