[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Word mail merge from Excel fails - "external table is not in the expected format"

Posted on 2011-03-15
4
Medium Priority
?
11,489 Views
Last Modified: 2012-05-11
DOC file with mail merge pulling fields from XLS file.  (2003 format, working since....2003)

XLS file (multi-user) saved to XLSX.
DOC file saved to DOTM.

If I'm on my laptop, I can open the DOTM off the file server, merge, then output to a new Word file.

If I'm on the Terminal Server, I can open the DOTM, but fail to connect to the XLSX.  Doesn't matter if I'm logged in as a user or administrator.

   Error has occured: External table is not in the expected format.
 error
Clicking OK gets me this:
 data link properties
The "Provider" tab looks like this...trying to use Access connector?
 provider
0
Comment
Question by:aleghart
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 32

Author Comment

by:aleghart
ID: 35143253
Running Microsoft's Component Checker from here to find MDAC version:

    MDAC 2.8 SP2 ON WINDOWS SERVER 2003 SP2


On my laptop:

    UNKNOWN


0
 
LVL 5

Accepted Solution

by:
KPAYNE123 earned 2000 total points
ID: 35143286
I beleive the blank password is the problem. There are a couple things to try. Open Access first - don't ask why but it works - then close access and try again. Another option is to open the Excel file and do merge with it open. Try them both and let me know which one works.
0
 
LVL 32

Author Comment

by:aleghart
ID: 35143429
Open Excel file first - no joy

Open Access first -  hmm...it's trying to "configure" Access now.

I updated 2003 to 2007 for all apps.  Then, updated everything to 2010 _except_ Access, because we're using some things that were deprecated after 2007.

waiting....waiting.....users are complaining that the TS is slow, but better than nothing at this point.

Open Access first - no joy
0
 
LVL 32

Author Closing Comment

by:aleghart
ID: 35144033
OK.  Belay that last.  Launching Access 2007 wasn't enough.  I had to launch Access 2010 also, and let it finish the "configuring" process.  Makes sense.  Don't know why I didn't do it at the same time.

Now the DOTX file opens and pulls from the XLSX file without my having to open the Excel file first.

Thanks for the help!

My TS users will be happier tomorrow.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question