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
 General SQL Server Forums
 New to SQL Server Programming
 Word Documents

Author  Topic 

Woahh
Starting Member

1 Post

Posted - 2006-02-22 : 13:12:22
Yesterday I installed MS SQL 2000 for the first time and have no idea what I'm doing.

I have been sent a database and asked to convert this to MS Access, for most of the data that is ok and I have already managed to do this. My problem is that the database contains MS Word documents stored in some of the tables (field type - image). I need to extract these from the database and get them back to individual Word files, ideally with a file name that relates them to the primary key of the table from which they came.

I have less that 24 hours experience with SQL server and would be very grateful if anyone can explain how I can do this.

Thank you for your help

Shane

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-22 : 13:48:22
SQL Server does not have the capability to extract the bits out of an image column to recreate the original document. You will need to write a front-end application to do this for you. So you just need to decide which programming language to use to do this. Once you know this, I'd suggest posting your question on a forum that specifically deals with that programming language.

Tara Kizer
aka tduggan
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-23 : 01:19:12
Also refer this
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -