Error querying excel file, "Could not find installable ISAM"

[Job Lot]

i am querying excel file as follows

Dim conn As New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source='" &
"C:\Temp\SSPortfolio.xls" & " '; " & _
"Extended Properties=Excel 8.0;" &
"HDR=Yes;" & "IMEX=1")
'! Select the data from Sheet1 of the workbook.
Dim da As New OleDbDataAdapter("SELECT * FROM [SSPortfolio$]", conn)

Dim ds As New DataSet

da.Fill(ds)

DataGridView1.DataSource = ds.Tables(0)

but getting an error message saying "Could not find installable ISAM". what
thia error cud be???

thanks

[Paul Clement]

On Wed, 23 Nov 2005 19:15:01 -0800, "Job Lot" <Jo****@discussions.microsoft.com> wrote:

¤ i am querying excel file as follows
¤
¤ Dim conn As New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " & _
¤ "data source='" &
¤ "C:\Temp\SSPortfolio.xls" & " '; " & _
¤ "Extended Properties=Excel 8.0;" &
¤ "HDR=Yes;" & "IMEX=1")
¤
¤
¤ '! Select the data from Sheet1 of the workbook.
¤ Dim da As New OleDbDataAdapter("SELECT * FROM [SSPortfolio$]", conn)
¤
¤ Dim ds As New DataSet
¤
¤ da.Fill(ds)
¤
¤ DataGridView1.DataSource = ds.Tables(0)
¤
¤ but getting an error message saying "Could not find installable ISAM". what
¤ thia error cud be???

Usually an indication of a bad connection string. Try something like the following:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Temp\SSPortfolio.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""

Dim ExcelConnection As New System.Data.OleDb.OleDbConnection(ConnectionString )
ExcelConnection.Open()
Paul
~~~~
Microsoft MVP (Visual Basic)