Limiting size field MS query returns

L

LarryLL

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

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

Thank
 
Top