Identify macros in a document using T-SQL

Question

Hello all,

I have an assignment as shown below:

I have 50 MS Word files (.doc), out of these files some of them used "macros" and some are not .

So i have to identify name of those files which contains macros and save those name to a table.

Can it is possible with SQL Server 2008 R2, If yes than how.

If no , then please suggest a tool which can do this for me.

Thanks in advance.

---

Pankaj Kumar Yadav-

Answer 1

Nothing to do with SQL server not meant for.  You may refer the below link:

http://www.ozgrid.com/forum/showthread.php?t=58216

Once you got the filenames, you can store the info in SQL table definitely.

---

Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

Answer 2

Hi Pankaj,

Please see this blog:

http://chiragrdarji.wordpress.com/2007/08/31/storing-and-retrieving-docpdfxls-files-in-sql-server/

It describes how to store and retrieve doc files in sql server.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

Hi Pankaj,

I’m writing to follow up with you on this post. Was the problem resolved after performing our action plan steps?

If you are satisfied with our solution, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.   

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

Thanks Iric Wen for your effort.

---

Pankaj Kumar Yadav-