Thread: MSQuery question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LarryLL[_3_] LarryLL[_3_] is offline
external usenet poster
  
Posts: 1
Default MSQuery question

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=560453

Reply With QuoteReply With Quote