Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 12019
  • Last Modified:

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

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
aleghart
Asked:
aleghart
  • 3
1 Solution
 
aleghartAuthor Commented:
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
 
KPAYNE123Commented:
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
 
aleghartAuthor Commented:
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
 
aleghartAuthor Commented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now