Data link properties / ODBC Excel driver login failed

[Jarrod]

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.

 

[Guest]

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.

 

[Jamie Collins]

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.

--