When trying to perform a mail merge, after selecting my excel spreadsheet for
names and addresses, I get a Data Link Properties window that opens. It has
provider, connection, advanced, and all tabs. When I click OK I get ODBC
Excel driver login failed. Could not find installable ISAM. Clicking OK does
nothing clicking cancel tries to bring up the spreadsheet. This only happens
on this workstation. All workstations are XP with Office XP with latest
service packs.

hi.
ISAM (Indexed Sequential Access Method) is a file
management system developed at IBM that allows records to
be accessed either sequentially (in the order they were
entered) or randomly (with an index).
where as i knew what ISAM was, i didn't know it was an
installable device. you are apparently missing this. How
to get it?
don't know. sorry.

>-----Original Message-----
>When trying to perform a mail merge, after selecting my
excel spreadsheet for
>names and addresses, I get a Data Link Properties window
that opens. It has
>provider, connection, advanced, and all tabs. When I
click OK I get ODBC
>Excel driver login failed. Could not find installable
ISAM. Clicking OK does
>nothing clicking cancel tries to bring up the
spreadsheet. This only happens
>on this workstation. All workstations are XP with Office
XP with latest
>service packs.
>.
>

Jarrod <(E-Mail Removed)> wrote ...

> When trying to perform a mail merge, after selecting my excel spreadsheet for
> names and addresses, I get a Data Link Properties window that opens. It has
> provider, connection, advanced, and all tabs. When I click OK I get ODBC
> Excel driver login failed. Could not find installable ISAM. Clicking OK does
> nothing clicking cancel tries to bring up the spreadsheet. This only happens
> on this workstation. All workstations are XP with Office XP with latest
> service packs.

I sometime see the 'Could not find installable ISAM' message when my
connection string contains a typo.

The Data Link Properties window may be used to generate an OLE DB
connection string e.g. try this:

Sub Test()
Dim oDLink As Object
Set oDLink = CreateObject("DataLinks")
On Error Resume Next
MsgBox oDLink.PromptNew
End Sub

Are you entering any details? You mention odbc so presumably you are
selecting the OLEDB provider for odbc. Perhaps you are entering some
details incorrectly.

Another thing to check would be that the registry settings are present
and correct e.g. if I rename this key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel

to xxxExcel, then my subsequent Jet 4.0 queries to Excel data sources
fail with the 'Could not find installable ISAM' message.

What all this has to do with a mail merge, I don't know <g>.

Jamie.

--

[Maur]

I am getting this error as well and I'm thinking it has to do with drivers of some sort because the connection string works on other PC's. Anyone find out what drivers in particular I'd be looking for or would have to update?