SQL 255 character limit

[DB]

I'm using ADO within Excel. I have an Excel userform with a textbox that a
user keys a long description. I assing that text to a variable in my SQL
INSERT statement and 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,

 

[Douglas J. Steele]

You might get a better response if you ask in a newsgroup related to Excel.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

 

[DB]

Douglas,

I have posted this on the Excel site and many other sites. This is a
specific SQL question because I also query Access using ADO through Excel.

I'll keep asking.

 

[Pat Hartman\(MVP\)]

Text fields in Access are limited to 255 characters. If you need to store
more, you need to change the data type to Memo.