I have a table that has Word files stored in it. I need to include each word file into a report or mail merge it into another word document.
I am having a problem working with a Word file that has been stored in the database.
I have a web site where I allow clients to upload a Word document. I store this Word file in a MySQL database using a BLOB field.
I then use ODBC to connect to this database and import the table into Microsoft Access 2000. From there I do some sorting and preping of the data. Next from within MS-Access I need to print reports that include the Word file as part of the printed report along with other information from other tables.
I do know for certain that the upload of the Word file into the database works, because I am able to download and open the Word file back from the database (from the internet).
When I import the MySQL data into Access 2000 and the table is constructed, the field that holds the binary file is an OLE field (the field type in the MySQL table is a BLOB) and the field says Long Binary Data
I am missing a step somewhere and would appreciate any help someone can offer
1.) I am looking for just the code portion of this.
2.) Code must be able to read the Word files from within the table and print it in a report and allow me to include other data from other linked tables.
3.) Any VB code must be in Access 2000 format NOT addon program
Must work in Access 2000