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

 

[Meldric]

Not positive, but you might have to split the string into two and put them in seperate cells. I could not get excel to take anything over 255 characters no matter what I tried.

Roger

 

[FengShui1998]

xenomage,

I was able to place a string longer than 255 char into a cell using vbscript. Excel is from Office 2000.

Dim objXL
Set objXL = WScript.CreateObject("Excel.Application&quot

objXL.Visible = TRUE

objXL.WorkBooks.Add

objXL.Cells(1, 1).Value = "123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789

123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789

123456789 123456789 123456789 123456789 123456789 123456789 "

---------------------------------
fengshui_1998