Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Brenda from Michigan Brenda from Michigan is offline
external usenet poster
 
Posts: 85
Default ODBC & ISAM Errors

User has Excel 2003

A co-worker (gone now) setup a merge for this user to merge an Excel
database into Word. When the merge happens, a dialog box opens followed by a
"ODBC Excel Driver Login Failed" error and again followed by "No installable
ISAM driver found" error.

I setup her Word to Confirm Conversion At Open attempting to select DDE
instead of ODBC, but the dialog box prompt for this does not open. It just
opens the other dialog box (I don't know if co-worker created this or what)
followed by the above two errors. How can I force it to prompt so I can
select DDE? TIA1
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default ODBC & ISAM Errors

Try checking Word Tools-Options-General-COnfirm conversions at open.
Then, after you have selected the data source, you should see a dialog
called "Confirm Data Source" that lets you select the connection type.
If OLE DB (the default) works for you, then I would choose it. However,
a number of things might require you to use DDE, e.g., if the workbook
is password-protected, OLE DB cannot open it and DDE is your only simple
option.

Peter Jamieson

http://tips.pjmsn.me.uk

On 25/03/2010 14:28, Brenda from Michigan wrote:
User has Excel 2003

A co-worker (gone now) setup a merge for this user to merge an Excel
database into Word. When the merge happens, a dialog box opens followed by a
"ODBC Excel Driver Login Failed" error and again followed by "No installable
ISAM driver found" error.

I setup her Word to Confirm Conversion At Open attempting to select DDE
instead of ODBC, but the dialog box prompt for this does not open. It just
opens the other dialog box (I don't know if co-worker created this or what)
followed by the above two errors. How can I force it to prompt so I can
select DDE? TIA1

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Brenda from Michigan Brenda from Michigan is offline
external usenet poster
 
Posts: 85
Default ODBC & ISAM Errors

Please re-read my 2nd paragraph. Been there, done that. The dialog box that
I expect to see which allows me to change from ODBC to DDB simply does not
open up so I cannot change the conversion type.

"Peter Jamieson" wrote:

Try checking Word Tools-Options-General-COnfirm conversions at open.
Then, after you have selected the data source, you should see a dialog
called "Confirm Data Source" that lets you select the connection type.
If OLE DB (the default) works for you, then I would choose it. However,
a number of things might require you to use DDE, e.g., if the workbook
is password-protected, OLE DB cannot open it and DDE is your only simple
option.

Peter Jamieson

http://tips.pjmsn.me.uk

On 25/03/2010 14:28, Brenda from Michigan wrote:
User has Excel 2003

A co-worker (gone now) setup a merge for this user to merge an Excel
database into Word. When the merge happens, a dialog box opens followed by a
"ODBC Excel Driver Login Failed" error and again followed by "No installable
ISAM driver found" error.

I setup her Word to Confirm Conversion At Open attempting to select DDE
instead of ODBC, but the dialog box prompt for this does not open. It just
opens the other dialog box (I don't know if co-worker created this or what)
followed by the above two errors. How can I force it to prompt so I can
select DDE? TIA1

.

  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default ODBC & ISAM Errors

Please re-read my 2nd paragraph. Been there, done that.

Sorry about that.

Off the top of my head,
a. if Word doesn't present the Confirm dialog box, it could be because
it believes it knows the format, e.g. if the file had extension .xls but
was in fact a Word .doc
b. In that particular scenario, a quick check says that you wouldn't
(ordinarily) see an ODBC dialog box next.
c. But perhaps it's something along those lines.

So, the obvious stuff..
a. does it have a .xls extension? And can you open it in Excel? I
don't suppose the merge could have been set up so it connected via a
..dsn or machine DSN, or a .udl or .odc?
b. Does a newly created file of the same type cause similar problems?

Peter Jamieson

http://tips.pjmsn.me.uk

On 26/03/2010 12:33, Brenda from Michigan wrote:
Please re-read my 2nd paragraph. Been there, done that. The dialog box that
I expect to see which allows me to change from ODBC to DDB simply does not
open up so I cannot change the conversion type.

"Peter Jamieson" wrote:

Try checking Word Tools-Options-General-COnfirm conversions at open.
Then, after you have selected the data source, you should see a dialog
called "Confirm Data Source" that lets you select the connection type.
If OLE DB (the default) works for you, then I would choose it. However,
a number of things might require you to use DDE, e.g., if the workbook
is password-protected, OLE DB cannot open it and DDE is your only simple
option.

Peter Jamieson

http://tips.pjmsn.me.uk

On 25/03/2010 14:28, Brenda from Michigan wrote:
User has Excel 2003

A co-worker (gone now) setup a merge for this user to merge an Excel
database into Word. When the merge happens, a dialog box opens followed by a
"ODBC Excel Driver Login Failed" error and again followed by "No installable
ISAM driver found" error.

I setup her Word to Confirm Conversion At Open attempting to select DDE
instead of ODBC, but the dialog box prompt for this does not open. It just
opens the other dialog box (I don't know if co-worker created this or what)
followed by the above two errors. How can I force it to prompt so I can
select DDE? TIA1

.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: could not find installable ISAM during Mail Merge RS Mailmerge 4 July 8th 09 01:10 AM
can't find installable ISAM Dave_S Mailmerge 1 March 12th 09 09:59 PM
Cant find installable ISAM Duane Reynolds 322310 Mailmerge 1 August 19th 08 11:08 PM
what is an installable isam bcastro Mailmerge 1 June 25th 08 06:36 AM
Cannot Find installable ISAM abs Mailmerge 1 December 16th 04 10:44 AM


All times are GMT +1. The time now is 04:14 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"