asked
Storing documents in SQL Server
Hi All, I have some documents(in form of excel or word) .I planned to store these documents in database. Once they are placed in database. I need to acess them through web interface. Is it possible..? If yes give me some hints how it can be done
Hi, you can store excel or word documents in SQL Server database without any problems. You will store them in field of type `varbinary(max)`. The mechanism how to access them though the web will depend on what you use to design the web. (PHP, ASP etc.). For more information how to access the database though the web interface you will probably need info from other site as this is related to the SQL Server itself.
Yes, varbinary(max) is the datatype to store such documents in sql server 2005. If you would be using PHP then this link may be helpful
http://phpexcel.codeplex.com/ Otherwise, if you are using .NET you can visit
http://chiragrdarji.wordpress.com/2007/08/31/storing-and-retrieving-docpdfxls-files-in-sql-server/
http://forums.asp.net/t/1362891.aspx/1
