"Could not find Installable ISAM"

Im trying to import Data from an Access DB to an Excel Spreadsheet, the Code gives me the error

Run-time error '-2147467259(80004005)'
Could not find Installable ISAM

on the line cn.Open...

VB Code:

Dim cn As ADODB.Connection, rs As ADODB.Recordset, intColIndex As Integer
    ' open the database
    Set cn = New ADODB.Connection
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
        tstDBFullName & ";" & "UID=myuname ;PWD=xyzu "
    Set rs = New ADODB.Recordset

Your Access connectionstring should be without the spaces and pwd should be Password.

VB Code:

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & tstDBFullName & ";User Id=admin;Password=;"

Whats the value for tstDBFullName?

i would look on Microsoft support..:

http://support.microsoft.com/default...b;en-us;283881

Quote:

---

Originally Posted by Br1an_g

i would look on Microsoft support..:

http://support.microsoft.com/default...b;en-us;283881

---

I had already gone through those steps on the page but thanks anyways.

The spaces and password did get me out of the ISAM error but now can anyone tell me how to incorporate a workgroupd file here for this authentication coz it says tht the workgroups information file is missing or opened exclusively by another user.

nevermind the workgroup problem.....I fixed it by adding

Jet OLEDB:System database=C:\SYSTEM.MDW;" at the end

so its now

VB Code:

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBFullName & ";User Id=manektalau1;Password=;Jet OLEDB:System database=C:\SYSTEM.MDW;"