File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

memo data type in ms access

 
xue shen
Greenhorn
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have used the memo type in access to store a large string text thinking that memo data type does not have a character size limit(correct me if I am wrong). I do not have access to a help file at the moment. When I am trying to access the memo data from by using jdbc, resultset.getString(index), it does not work. What data type is memo corresponds to in Java, Do I need to use a characterStream, a Ascii stream, a binary stream to access it?
Do you guys have any suggestions on this?
Thanks
XS
 
Asanka Nanayakkara
Greenhorn
Posts: 10
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
did you try "resultset.getBlob(index)" ?
Asanka
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this is working code to update a memo field in MSAccess. Try reversing to read the data in. I'll try to find a link to the code you need.
hope it works for you,
Jamie
[ August 14, 2002: Message edited by: Jamie Robertson ]
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
found it! Lots of streaming examples here. It's on the oracle site so you might have to register.
Jamie
[ August 14, 2002: Message edited by: Jamie Robertson ]
 
xue shen
Greenhorn
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jamie and Asanka;
Thanks very much for your suggestion. I will reply to you guys about the outcome.
X.S.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic