Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes retrieve MS word from ACCESS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "retrieve MS word from ACCESS" Watch "retrieve MS word from ACCESS" New topic

retrieve MS word from ACCESS

Clara Hall

Joined: Nov 24, 2001
Posts: 16
I store a MS word file in the Access database in the type of OLE. Now I want to retrieve the file and send it to client. How can I retrieve the file? It seems getObject(String), getBinaryStream(String), and getAsciiStream(String) don't work well. Can anybody give me some suggestion? Thank you in advance.

Joined: Nov 23, 2001
Posts: 6
Dear Clara,
I have a similar problem like yours. I have stored pictures as OLE Objects in MS Access (instead of Word Documents) and can't use them in my program. I think, using the "getBytes()" method of ResultSet can be a solution. However it did not work.
If you can find a solution for your problem please inform me. And if I can find a solution I'll inform you.
Onur K. GAGO

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />Onur Kutlu GAGO<br />visit my page at:<br /><a href="" target="_blank" rel="nofollow"></a><br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I agree. Here's the link:
subject: retrieve MS word from ACCESS
It's not a secret anymore!