Solved

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

Posted on 2011-03-15
4
10,386 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 500 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

Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

732 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