How to retrieve a word document to excel via database

Question

Hi

Am an automation tester by profession.

Am not that sound with codes. I have an overview of the thing i am gonna do and request you guys to kindly help me with how i can proceed.

This is an example of my orginal idea. It goes like this :

1. Say I have a word document which consist of definitions for words ( say like a normal definition).

2. Now i want to store this word document in a database.

3. Now in an excel sheet i create a list box with words for which definitions are provided in the word document.

4. Now when i select a word, say " apple" from dropdown list in the excel sheet it should fetch the definition of apple from the word document stored in the database.

Is it possible to do this way or is there a simpler way to do it.

Anticipating your early response

Answer 1

Hi Sriperforms,

Thank you for posting.

I think it possible to write the word document to SQL Server database. For more details, you can refer to the two threads:

http://social.msdn.microsoft.com/Forums/en-US/oxmlsdk/thread/1040fbc6-d8f5-4c0d-8621-59d782a91cc0

http://social.msdn.microsoft.com/forums/en-US/winformsdatacontrols/thread/d1e395ab-9c13-4eda-9077-8040ddf06ce2/

And the following two articles on MSDN about this:

http://msdn.microsoft.com/en-us/library/4f5s1we0(v=vs.100).aspx

http://msdn.microsoft.com/en-us/library/87z0hy49(v=vs.100).aspx

As for fetching the definition of apple, you can read BLOB data from the SQL Server and write it to the disk. Then, you can use word API to manipulate the word document and get the definition of apple.

Hope this can give you the hint and just feel free to follow up after you have tried.

Best Regards,

---

Bruce Song [MSFT]
MSDN Community Support | Feedback to us