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 |
|
olily
Starting Member
37 Posts |
 Posted - 2002-05-08 : 01:57:52
|
| My user requires to save files in database although I know it's not a good practise to do so. The files are sent by one person and needed to forward to others after some input has been made to my system. BTW, I'm using VB6. Please advice.Edited by - olily on 05/08/2002 01:59:08 |
|
|
Peter Dutch
Posting Yak Master
127 Posts |
Posted - 2002-05-08 : 04:16:11
|
| You have to binary read the document and write it to the db.To write it you could use the ADODB.RecordSet.AppendChuck methodThe datatype should be TEXT.I bet there are a lot of examples to do this, maybe check google. It's actually the same as storing images. |
 |
|
|
olily
Starting Member
37 Posts |
Posted - 2002-05-08 : 04:30:53
|
| I found the method to save image file but no example for .xls and .doc files. I tried the example and I can save image file successfully but when I tried to save .xls, my file turned out to be rubbish after I retrieved it. What is the datatype should I use in Sql server to store these type of files? If I use TEXT, would it be able to store image? Any example that I can find? I'm using VB6, Mdac2.6 and Sql Server 7.0.Edited by - olily on 05/08/2002 04:31:24 |
|
|
|
|
|
|
How to save any file types in Sql database?