Cannot import Excel data

[LuxCoder]

I am getting this error :

Could not find installable ISAM.

While trying to import my excel data into sql express database using following:

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()

Any suggestions?

Lux.

[stanav]

Provider=Microsoft.Jet.OLEDB.4.0;DataSource=d:/test/Places.xls

I'm not sure that this is the problem, but shouldn't the path separator be "\" instead?

[LuxCoder]

Done that! Still getting same error

[stanav]

This looks very suspicious to me:

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)

I don't know if it's OK to insert new records that way since I've never done it like that (and never seen it's being done like that either). What I normally do is to pull the data from excel into a dataset/datatable, and then insert the records from the dataset/datatable to the database in a separate step.

[LuxCoder]

ok.. can u give me an example?

[LuxCoder]

After some modifications i used the following command to import:

SELECT  Slno, State, District, City, Village, pincode
INTO       [D:\PROJECTMW\MACHINEWALE\MACHINEWALE\databasemw.mdf].locations
FROM     OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\Test\Places.xls;IMEX=1', 'SELECT * FROM [Place$]') AS derivedtbl_1

But i got the following error:

"The specified schema name "D:\PROJECTMW\MACHINEWALE\MACHINEWALE\databasemw.mdf" either does not exist or you do not have permission to use it."

what to do now?