By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,212 Members | 2,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,212 IT Pros & Developers. It's quick & easy.

cataloging MS Word Docs with ASP.NET and SQL

P: n/a
MDB
Once again, just looking to see if my thinking is off base (there's that
naivete again) or if there's a better approach. The requirement is for users
to create MS Word documents that will eventually find their way into a
central directory on the server. Once they're in that place, I'm looking for
a way to 'catalog' them, in effect, extracting information from data fields
in each document, as well as the document's location as a URL, to store in a
SQL database, and then, of course, use an ASP.NET application for other end
users to view the documents in their browser. Please note that the need is
NOT to store the entire document in the SQL db, just data from fields that
would be on the template that all the Word documents would be created from.
However, access those fields from an ASP.NET application appears to involve
invoking the Word object over and over again, and tests have been wholly
unsatisfactory. I've considered a VBScript, but would not have a central
location to place the macro, and so haven't even tested that approach. The
information I would need to store about each document include various
categories concerning the document's contents, so it isn't just a matter of
reading the directory and scooping up document names. Is there any other
approach that I could possibly consider?

MDBloemker
md********@hotmail.com
Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I suggest you look into using this product:
http://officewriter.softartisans.com...ewriter-8.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net

"MDB" <md*@hotmail.com> wrote in message
news:wI********************@telcove.net...
Once again, just looking to see if my thinking is off base (there's that
naivete again) or if there's a better approach. The requirement is for users to create MS Word documents that will eventually find their way into a
central directory on the server. Once they're in that place, I'm looking for a way to 'catalog' them, in effect, extracting information from data fields in each document, as well as the document's location as a URL, to store in a SQL database, and then, of course, use an ASP.NET application for other end users to view the documents in their browser. Please note that the need is
NOT to store the entire document in the SQL db, just data from fields that
would be on the template that all the Word documents would be created from. However, access those fields from an ASP.NET application appears to involve invoking the Word object over and over again, and tests have been wholly
unsatisfactory. I've considered a VBScript, but would not have a central
location to place the macro, and so haven't even tested that approach. The
information I would need to store about each document include various
categories concerning the document's contents, so it isn't just a matter of reading the directory and scooping up document names. Is there any other
approach that I could possibly consider?

MDBloemker
md********@hotmail.com

Nov 18 '05 #2

P: n/a
Check out this KB article:

http://support.microsoft.com/?kbid=224351

-Jason

MDB wrote:
Once again, just looking to see if my thinking is off base (there's that
naivete again) or if there's a better approach. The requirement is for users
to create MS Word documents that will eventually find their way into a
central directory on the server. Once they're in that place, I'm looking for
a way to 'catalog' them, in effect, extracting information from data fields
in each document, as well as the document's location as a URL, to store in a
SQL database, and then, of course, use an ASP.NET application for other end
users to view the documents in their browser. Please note that the need is
NOT to store the entire document in the SQL db, just data from fields that
would be on the template that all the Word documents would be created from.
However, access those fields from an ASP.NET application appears to involve
invoking the Word object over and over again, and tests have been wholly
unsatisfactory. I've considered a VBScript, but would not have a central
location to place the macro, and so haven't even tested that approach. The
information I would need to store about each document include various
categories concerning the document's contents, so it isn't just a matter of
reading the directory and scooping up document names. Is there any other
approach that I could possibly consider?

MDBloemker
md********@hotmail.com

Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.