Won't Find Table

[Jeff]

I have a computer that I am trying to create a mail merger. The mail merger
works on all of our other computers except these one. After I select the
data file (an excel file), the window does not show any table to use. When
I compare the macro code, the only thing I notice different is the
Connection:= is"DNS=Excel Files; instead of the Connection:=
"Provider=Microsoft.Jet.OLEDB.4.0;". The computers with the
Microsoft.Jet.OLEDB work fine.



How do I get the other computer to use Microsoft.Jet.OLEDB instead of DSN?
Or this their something else causing my problem?

 

[Cindy M -WordMVP-]

Hi Jeff,

which version of Word is installed on this "problem" machine?

It sounds like the other machines certainly have Word 2002 or 2003 installed,
where OLE DB is used for the connection by default.

What you describe is an ODBC connection (which I usually prefer to OLE DB for
Excel, BTW). That's not the default connection for Excel under ANY version of
Word; prior to Word 2002 DDE was the default.

Assuming this machine has the same version of Word as the other ones, then I'm
guessing the OLE DB provider for Access/Excel is missing, which is why it's
defaulting to ODBC. To get up and running immediately, you can certainly use
the ODBC connection. What you need to do is click the "Options" button in the
dialog box with that empty list (it would show named ranges), then activate all
the checkboxes you find in the next dialog box (System Tables is the critical
one).

I have a computer that I am trying to create a mail merger. The mail merger
works on all of our other computers except these one. After I select the
data file (an excel file), the window does not show any table to use. When
I compare the macro code, the only thing I notice different is the
Connection:= is"DNS=Excel Files; instead of the Connection:=
"Provider=Microsoft.Jet.OLEDB.4.0;". The computers with the
Microsoft.Jet.OLEDB work fine.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail