How to insert a WORD or EXCELL FILE INTO A FIELD ?

[TI5100]

i'd like to know how to insert a Word or Excell document in its native mode into a field in Microsoft's SQL 7.0. What type of field should I use and what are the limitations of the field type.

My goal is to be able to add a *.doc or *.xls file into a field for archieving purposes. The application I'm preparing relies on that specific matter, thus allowing the user to reuse the *.doc or *.xls file at a later stage in clicking on the file name to start either WORD or EXCELL.

Many thanks in advance to anyone who is able to help me in this matter.

 

[Guest_imported]

I posted a similar question earlier. My question was how to insert an image and store it in a field in SQL 7.0. I haven't solved it yet though :/ hopefully somone can help

 

[Marcha]

Well you could try to do it the same way as images are stored (binary/varbinary) however I'm not quite sure about how large files can be. Or store a referecnce to a file or archive (example user points to a file, use zip/whatever then write referecne into field).
Hmm quite difficult question, I hope you'll find answer.
Bob: As for images there is a special type 'Image' you should use that.
Good luck
Marcha

 

[Marcha]

A little addition to the Image question: You should read the SQL Books online, so far I'v found lot of useful info on using, storing etc...
Have fun!
Marcha

 

[Guest_imported]

I have tried storing a binary file before to sql6.5 using VB's AppendChunk and GetChunk functions. The function worked well but the resulting record size is more than double of the actual the image filesize. This means using SQL to archive any binary file type will require more disk space than what the actual file itself requires.