Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Limitations in MS Query?
I have a Word-document that collects data from a database through MS Query
and joing them to a letter. This has been working very well until just recently. It seems that if a field in the database contains a very long text MS Query is unable to handle the data. In my example a field in the database containing 42219 characters in 595 rows causes MS Query to crash. Does anyone know the exact number of characters or rows that is the maximum content in a field in MS Query? I will need to redesign my database and it would be very helpful if I could get the exact number instead of doing trial and error. -- Jonas |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Limitations in MS Query?
Hi ?B?Sm9uYXMgTHVuZHF2aXN0?=,
MS Query is actually "owned" by the Excel application. You might try asking there. In a general sort of way, since Word 2000, Word itself should be able to handle roughly 65'000 characters coming from a "memo" field via an ODBC driver connection (which is what MS Query uses). I have a Word-document that collects data from a database through MS Query and joing them to a letter. This has been working very well until just recently. It seems that if a field in the database contains a very long text MS Query is unable to handle the data. In my example a field in the database containing 42219 characters in 595 rows causes MS Query to crash. Does anyone know the exact number of characters or rows that is the maximum content in a field in MS Query? 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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linked table parameter query | Mailmerge | |||
Mailmerge Query - Works in Access; fails in Word | Mailmerge | |||
Getting a Parameter to work in Microsoft Query | Mailmerge | |||
Mail Merge Access to Word using a Query | Mailmerge | |||
Can't Open Data Source (Query) where criteria is defined by functi | Mailmerge |