Microsoft Word -> Sql Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Microsoft Word -> Sql Server

Author

Topic

johncogan
Starting Member

20 Posts

Posted - 2004-02-18 : 04:53:20

Hi

Is it in any way possible to import data from a word document into SQL server (2000).

Some clients have asked if its' possible to take specific data within a *.doc file and storing it on the database.

One of the stranger requests I've had in a while :/

Best Regards
John

safigi
Starting Member

15 Posts

Posted - 2004-02-18 : 05:25:39

Yes you can use. You have to create image field for word documents in your sql table, and you can use adodb AppendChunk and GetChunk method of Fields object. There are some links:

For getchunk:
http://support.microsoft.com/?kbid=258038

You can search in word documents:
http://www.microsoft.com/sql/techinfo/tips/administration/importword.asp

Safi

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2004-02-18 : 05:45:44

The problem part of your requirement is the "specific data within a *.doc file" part.

Loading full documents into SQL can be achieved...but not advised (performance, ease of manipulation, etc)...search here for previous advice on this practice....maybe under the keyword "blob"

Loading segments of a Word Document into SQL...brings the headache that may not be solveable...of 1st locating the "interesting section of the word document"...and making unstructured information...structured. You may be better advised to get the relevent information in the word document to be saved external to word in a structured/controlled format...and linked through to word.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources