Hi ?B?TWFnaWVub2lyZQ==?=,
I'm using Office Word 2003 to insert an Access 2003 database. I don't recall
seeing a connection method option, so I assume I'm just using the default...
OK, that would mean the connection method is OLE DB. Let's try the other two that
ought to be available and see if one of them gives you a better result.
1. Tools/Options/General, activate "Confirm conversions on open".
2. Go through the steps to connect to the database table. When you select the file
and dismiss the dialog box, you should get a list that includes OLE DB, ODBC and
DDE. Try with ODBC first, then you can try with DDE (which may not work, depending
on your system's configuration). Is the result any better?
Why do Access database fields get truncated upon inserting a database table?
This can be a function of the connection method used (the data protocol used
to transfer the data into Word). Which version of Word/Office are you working
with? Are you specifically choosing a connection method, or just using the
default?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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 :-)