How do I write to a memo field in MS Access?

[Yvette Gonzalez]

I am reading a series of strings from a file and then inserting them into an MS Access table. Occasionally when the string is too large I get a java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]String data, right truncated (null).
The field in the table is of type memo and should be large enough to accomodate the size of the strings.
Any suggestions?
Thanks!

[Jamie Robertson]

some times drivers have limits to the size of the string that you can use for querying/updating. If the value is too large, usually you'll have to stream the values in. I got this code to work using MSAccess ( is probably far from efficient, and there may be a better way ):

PreparedStatement ps = con.prepareStatement( "Update table set memo_field = ? WHERE ..." )
String longString = "super duper long big...a couple thousand more characters...huge String"; 
int size = longString.length();
BufferedInputStream bais = new BufferedInputStream( new ByteArrayInputStream( longString.getBytes() ) );
ps.setAsciiStream( 1, bais, size );
ps.executeUpdate();

hope it works for you,
Jamie
[ August 12, 2002: Message edited by: Jamie Robertson ]

[Yvette Gonzalez]

Thanks Jaime, That's exactly what I was looking for!