| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limitations in MS Query?
This message was originally posted in the Word-discussion group, but I was
recommended to post it here instead: I have a Word-document that collects data from a database through MS Query and joins 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 -- Jonas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same | Excel Discussion (Misc queries) | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
| "Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
