Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass text 255 char. to closed wkb with SQL?
I'm using ADO ref 2.7 within Excel where I write SQL statements. I have an
Excel userform with a textbox where a user may key a long description. I assign the text to a variable in my SQL INSERT statement to add the record to a worksheet in a closed workbook. When the user keys a description longer then 255 characters, I receive an error. I know Excel can hold mor than 32k characters in a cell, how can I pass my users long description using SQL? Please help, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass text 255 char. to closed wkb with SQL?
Try this
http://www.dnzone.com/ShowDetail.asp?NewsId=234 Tim "DB" wrote in message ... I'm using ADO ref 2.7 within Excel where I write SQL statements. I have an Excel userform with a textbox where a user may key a long description. I assign the text to a variable in my SQL INSERT statement to add the record to a worksheet in a closed workbook. When the user keys a description longer then 255 characters, I receive an error. I know Excel can hold mor than 32k characters in a cell, how can I pass my users long description using SQL? Please help, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
cut-off text in cell.. I want excel to cut-off the text after # of char. | Excel Discussion (Misc queries) | |||
8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
Pass Strings 255 Char | Excel Programming |