File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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!