MEMO filed in MSAccess

[tbuch]

I am connecting to an Access database that has a memo field. Can anyone tell me how to get the data from the MEMO field into a JTextArea? I am currently just trying to run the query and assign the value from the query to the text area, but nothing is displaying. I am not getting any errors, just no data.

tbuch

 

[sedj]

Whats a "MEMO field" ?
How are you connecting to Access ?
How are you getting the "value" ?
Some *succinct* code ?

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[tbuch]

I answered my own question. I was testing for various data types, but overlooked LONGVARCHAR, which is what is returned from an Access MEMO field.

Thanx anyway!

tbuch