My error is "Could not find installable ISAM." Look at my followin code..How to solv it..Anythin missin??I m tryin to import excel file to sql
Dim connection As OleDb.OleDbConnection = New OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source= &FileName& ;ExtendedProperties=""Excel 8.0;HDR=YES;"";IMEX=1;")
connection.Open()
Dim command As OleDbCommand = New OleDbCommand("Select * FROM [{0}]", connection)
' Select the data from Sheet1 of the workbook.
Dim myTableName = connection.GetSchema("Tables").Rows(1)("TableName")
Dim da As OleDbDataAdapter = New OleDbDataAdapter(String.Format("SELECT * FROM [{0}]", myTableName), connection)
da.TableMappings.Add("Table", "FO")
Dim ds As DataSet = New DataSet()
da.Fill(ds)
return ds
connection.Close()
Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator