Office 2003: Saving directly to database

[Florian]

Hi,

I have not seen Office XP yet but I was told that it has a tight
integration with databases?

For example would be possible to save a word document (or information
from it) directly to a database?

I know my message is a little vague but maybe somebody can point me into
the right direction - thanks!

-Flo-

 

[Ty Anderson]

I am not sure what you mean by tight integration with databases but....

You cannot save a Word doc directly to a relational database like SQL
Server, Access or Oracle. You could write some VB/VBA code to store the doc
binary into a database is if you like, it is not hard to do.

Another option is Sharepoint Portal Server.

Within most Office XP applications (including Word), Sharepoint functions
are integrated into the FILE menu. It is very easy to save the document to
a Sharepoint repository. Now, Sharepoint is not a relational database but
it does provide some database like functions. Much like a relational
database, you can create queries using the PKMCDO objects.

If you could elaborate on what you are trying to accomplish I am sure I
could provide better info.

Ty Anderson