Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel text length > 255

Status
Not open for further replies.
xenomage

xenomage

Programmer
Jun 27, 2001
98
SG
hi all,

got this problem with my website which is suppose to convert data from sql server to be represented in excel.

objSheet.Range("C1").value = rstMain("Brief_Description")

but it seems like when the "rstMain("Brief_Description") is more that 255 in length, i can an "#Value!" in excel.

Any help is appreciated. Thanks
 
Status
Not open for further replies.

Similar threads

Brianfree
  • Locked
  • Question
Excel Rows to Column 1
Replies
2
Views
558
Brianfree
Brianfree
bdwilcox
  • Locked
  • Question
Validate that HTA text input boxes aren't blank on submission
Replies
1
Views
488
bdwilcox
bdwilcox
Katto
  • Locked
  • Question
Excel VBA functions in VBScript
Replies
4
Views
580
dhookom
dhookom
PiotrMP006
  • Locked
  • Question
How to quickly check if a file has 1 or more lines of text?
Replies
1
Views
461
combo
combo
asel
  • Locked
  • Question
Copy cell data from excel and paste into portable software application
Replies
0
Views
289
asel
asel

Part and Inventory Search

Sponsor

Back
Top