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.
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 helpShane |
|
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 Kizeraka tduggan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|