I am getting this error :
While trying to import my excel data into sql express database using following:Could not find installable ISAM.
Any suggestions?Code:Dim excelConnection As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=d:/test/Places.xls;Extended Properties=Excel 8.0;") excelConnection.Open() Dim excelCommand As New System.Data.OleDb.OleDbCommand("INSERT INTO Locations [OBDC; Driver={SQLServer};Server=(local);Database=D:\PROJECTMW\MACHINEWALE\MACHINEWALE\DATABASEMW.MDF;Trusted_Connection=yes].[Places]SELECT * FROM [Place$];", excelConnection) excelCommand.ExecuteNonQuery() excelConnection.Close()
Lux.




Reply With Quote