Mail merge Word Excel, Could not find installable ISAM

How are you connecting to the data source?

Go to File>Options>Advanced and scroll down to the General Section of the dialog and check the box for "Confirm file format conversion on open".  Then when you connect to the data source, a Confirm Data Source dialog should appear with the default OLE DB Database Files.  Then when you click on OK in that dialog, you will be presented with a Select Table dialog in which you can select the source of the data in the Workbook that you have selected.

Hi Doug,

Thanks for answering.

I connect to the data source by means of the Word Mail Merge utility.

Up to last week I could select an Excel data source file just by selecting it. Now I run into trouble (after a total Office reinstall)

First: I changed the check-box to 'Checked'

Steps for mail merge (#-steps are new after checking the box)

• First create an Excel file with some usable columns and lines
• In Word: Mailings -> Select Recipients -> Use an existing list
• Select the Excel (data source) file
• Click Open
• # The 'Confirm Data Source' dialog pops up
• # Select 'OLE DB Database files'
• # Click OK
• Now the ''Could not find installable ISAM' message pops up.

Still no success. :-(

Hans

Try going to the Control Panel>Uninstall a Program and then select Microsoft Office Professional Plus 2013 and then click on Change and then on Add or Remove Features and then check that Microsoft Access is set to "Run all from My Computer"

As a work-around, in the Confirm Data Source dialog, click the Show All box and then try connecting to the data source via the DDE method.

Just as an observation because I do not know what is wrong, but Word 2013 would I think use the ACE database engine (the successor to Jet from Office 2007 onwards). The registry keys and file that I have for that here on a similar configuration are as follows:

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Access Connectivity Engine

c:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\ACEEXCL.DLL

Probably worth at least having a look for that. If you have the 365 version of Office, the regitry key structure is very different and the file is more likely to be in the following folder:

C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\OFFICE15

Try going to the Control Panel>Uninstall a Program and then select Microsoft Office Professional Plus 2013 and then click on Change and then on Add or Remove Features and then check that Microsoft Access is set to "Run all from My Computer"

As a work-around, in the Confirm Data Source dialog, click the Show All box and then try connecting to the data source via the DDE method.

Doug,

Sorry for the late response. Busy this time of the year.

Checked the Microsoft Office features. They are all set to: 'Run all from My Computer'. So nothing can be upgraded here.

The DDE methode seems not to work, as the DDE methode only finds the first the first TAB of my spreadsheet.

Any more ideas are welcome.

Hans

Just as an observation because I do not know what is wrong, but Word 2013 would I think use the ACE database engine (the successor to Jet from Office 2007 onwards). The registry keys and file that I have for that here on a similar configuration are as follows:

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Access Connectivity Engine

c:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\ACEEXCL.DLL

Probably worth at least having a look for that. If you have the 365 version of Office, the regitry key structure is very different and the file is more likely to be in the following folder:

C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\OFFICE15

Peter,

I do find the ACEEXCL.DLL on the location mentioned. No registry keys pointing to this file however :(

Hans

I suggest you try to re-register the DLL - open a command prompt (sorry, I wil have to leave you to find out how to do that on Win 8.1) and run the following command:

regsvr32 aceexcl.dll

Peter,

Finding the command prompt is not that a big problem :)

Running rgsvr32 on the DLL seems not to give the desired results. A message pops up:

The module "aceexcl.dll" was loaded but the entry-point DllRegisterServer was not found.

Make sure that "aceexcl.dll" is a valid DLL OR OCX file and then try again.

Hans