Limiting size field MS query returns
 

I am using MS Query to retrieve information from a database, and return
the data to excel. Normally this works fine, however if the db field
contains more than 32K characters, Excel crashes.

Is there a way to specify in my database query not get more than the
first 2500 characters of a particular field?

Thanks


--
LarryLL
------------------------------------------------------------------------
LarryLL's Profile: http://www.excelforum.com/member.php...o&userid=36136
View this thread: http://www.excelforum.com/showthread...hreadid=559109