Limitation for length of insert statement?

[jgoodman00]

I need to insert a very long string from a text area into an access table. The column is set as text datatype, & if I execute the sql which is generated by the asp page, from within access it executes perfectly. However, if I attempt the insert from an asp page, it fails with a multitude of errors from what looks like string truncation.

At the moment, I am dynamically creating a SQL string within my page & then using the Execute method of the Connection object to make the insert:

strSQL = "INSERT INTO SomeTable("TextColumn") VALUES ('" & Request.Form("TextArea") & "'"
objConn.Execute

Any suggestions?

James Goodman MCSE, MCDBA
[URL unfurl="true"]http://www.angelfire.com/sports/f1pictures[/URL]

 

[onpnt]

set it to a memo data type and you will be allowed greater lengths

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page

 

[jgoodman00]

Sorry, thats what I meant it is. It is a memo datatype. The problem is not with the db, as the insert can be made from within access.

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures

 

[onpnt]

you'll more then likely have to split the data up then to not exceed the buffer limits if the values are that great

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page