excel #value! error

[xenomage]

Hi all,

PLEASE HELP!!!

i'm using SQL Server and trying to place a string into an excel file like so.

objExcel.Range("A1&quot = rstMain("str&quot

This works fine if the string "rstMain('str')" is shorter than 255. But, if the string is more than 255, the cell in excel becomes a stupid #value!.

How can i solve this. PLEASE HELP!!

xenomage

 

[Mossoft]

May be SQL Server driver fault (KB Q170218 mentions something like your problem). Try upgrading driver.

M.

 

[xenomage]

hi M.

can provide me with a link to that article??

xenomage

 

[Mossoft]

http://support.microsoft.com/support/kb/articles/Q170/2/18.asp