My problem is :
I have an Access 2000 DB.
A table contains a field of type "OLE Data".
This field contains Microsoft Word's embedded documents.
What I want is to generate word documents for each of the record programatically in VB. But not succeeded yet.
I also need to do it from SQL Server 7 DB, as I have upsized my Access DB to SQL Server and it is exported in an Image type of field. How can I generate document files from this Access or SQL Server DB.
I tried to achieve it in 2 ways; first I tried:
Created a form, inserted a data control and an OLE control, bound it with the required field. When I run the VB program, it successfully opens the docudments from DB in the control. Then I tried to save the control data using "OLE1.SaveToFile" method to generate a document. It generated a document but unfortunately this document is not in the correct MS Word format so not opening in Word. And secondly I used Getchunk method but the result was same.
I hope you can understand my problem. I need a quick response. Thanks in advance for help.
Zaki
I have an Access 2000 DB.
A table contains a field of type "OLE Data".
This field contains Microsoft Word's embedded documents.
What I want is to generate word documents for each of the record programatically in VB. But not succeeded yet.
I also need to do it from SQL Server 7 DB, as I have upsized my Access DB to SQL Server and it is exported in an Image type of field. How can I generate document files from this Access or SQL Server DB.
I tried to achieve it in 2 ways; first I tried:
Created a form, inserted a data control and an OLE control, bound it with the required field. When I run the VB program, it successfully opens the docudments from DB in the control. Then I tried to save the control data using "OLE1.SaveToFile" method to generate a document. It generated a document but unfortunately this document is not in the correct MS Word format so not opening in Word. And secondly I used Getchunk method but the result was same.
I hope you can understand my problem. I need a quick response. Thanks in advance for help.
Zaki