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
Solved

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

Posted on 2011-03-15
4
9,845 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
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

808 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