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
 SQL Server Development (2000)
 inserting word document into database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-07 : 10:58:13
Mahendra writes "How can i insert a word document into sql server 7 database using
Visual basic program ?"

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2002-05-07 : 11:43:22
The general consensus is to discourage saving files in SQL tables. It's better to save the files in a directory on the OS and have a column in your table that holds the file name and path.

If you really need to store it in the DB, you'll need to use a BLOB field (binary large object) field such as image. You can save any sort of data in these up to about 2GB.

Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-05-07 : 23:18:36
Well said Timmy

Damian
Go to Top of Page

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-05-08 : 01:26:16
Thanx Timmy for your valuable information.
but i really, really want to store the BLOB into Database.
How can i?
Thanx in advance !!!

---------------------------
Sandesh - The Messanger
Go to Top of Page

chadmat
The Chadinator

1974 Posts

Posted - 2002-05-08 : 01:42:27
This article gives a good example

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q194975

-Chad

Go to Top of Page
   

- Advertisement -