Using SQL Insert to insert a value that could be thousands of chars long. getting Err 3271.

[BSUMLAUF]

I am trying to use an SQL Insert in my code with a parameter clause to pass data to the insert. One data element could potentially be several thousands of characters long. Using string as the value type. this works if the data element is not to long. What other data type can I use to handle several thousand characters?

[ItsMe]

I think you can store tens of thousands of characters in an SQL statement for a Query Object. I think the limit in a VBA string is like 255 or something. So the VBA thing does not have anything to do with the memory size of a variable that is type string.