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