Is it possible to save current word document into database as BLOB by Macro or VBA?
I need to manage my document by migrate into MySQL database as BLOB. Some of my document may be no need to migrate. So I will open and review all of them from MS-WORD then make a dicession that it need to be migrated to MySQL or NOT. I need it to easy as just click on one button in MS-WORD then prompt for some more information then save it to database.
Is my idea possible to do Macro or VBA?
FLOW OF WORK in my plan:
1. Open Document in MS-WORD for review.
2. If I need to keep this document, just click on some button to start a process.
3. Prompt some dialog box for ask some more information I need to keep with this document. (ie comment, category)
4. Then document be saved in database as blob with other information I input.
5. Do step 1-4 again and again for other documents.
Re: Is it possible to save current word document into database as BLOB by Macro or VBA?
Yes it is possible in VBA, but if you do not have any experience with VBA or ODBC it will be a Quest to achieve.
Re: Is it possible to save current word document into database as BLOB by Macro or VB
Thank You,
I have only little experience on VBA and some more on VB. Whatever I will try and for more information I will back again.