Pass text > 255 char. to closed wkb with SQL?

G

Guest

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL limit of 255 characters 2
255 char limit on TextBox 3
How to overcome Inputbox 255-char limit? 3
Varioable in SQL statement 4
copy cell contents to a textbox > 255 characters 7
Querytables.add with sql query text stored in separate text file 5
Access Memo field to Excel Textbox 1
Limitation of PivotCache.CommandText property 4

Top