Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Truncated Database fields
Why do Access database fields get truncated upon inserting a database table?
Is there a work-around solution? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Truncated Database fields
I'm not seeing this in either Office 2002 or 2003. If the data is too wide to
fit within the margins, the row height expands to allow text to wrap into multiple lines. Under what circumstances are your fields being truncated? How are you inserting the table, by copy-and-paste from a datasheet view? -- Ted |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Truncated Database fields
I've tried copy-paste from a datasheet view and insert database in Word (via
the insert database toolbar). The same results occurred, i.e., fields (up to a certain length) were truncated. It's the same problem as when you import the table into Excel. I understand that Excel has a text length limitation on text fields. Is this the same with Word? "TedMi" wrote: I'm not seeing this in either Office 2002 or 2003. If the data is too wide to fit within the margins, the row height expands to allow text to wrap into multiple lines. Under what circumstances are your fields being truncated? How are you inserting the table, by copy-and-paste from a datasheet view? -- Ted |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Truncated Database fields
Hi ?B?TWFnaWVub2lyZQ==?=,
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 :-) |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Truncated Database fields
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... "Cindy M." wrote: Hi ?B?TWFnaWVub2lyZQ==?=, 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 :-) |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Truncated Database fields
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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Truncated merge fields | Mailmerge | |||
Update fields of mail merge based on lookup to database | Mailmerge | |||
Mailmerge with Excel as a database... Suppressing zero's in fields | Mailmerge | |||
WHEN MERGING EXCEL DATABASE, ERROR SAYS LOCKED FIELDS ? | Mailmerge | |||
How to insert only selected fields from Access database in Word? | Microsoft Word Help |