Solved

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

Posted on 2011-03-15
4
8,922 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
  • 3
4 Comments
 
LVL 32

Author Comment

by:aleghart
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now