Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nisarg Upadhyay How to store Excel files In SQL Table RE: How to store Excel files In SQL Table

  • December 7, 2017 at 6:18 am

    #1971150

    fregatepallada - Thursday, December 7, 2017 1:17 AM

    Complete LUNACY. 
    I highly recommend you to read this first https://www.microsoft.com/en-us/research/wp-content/uploads/2006/04/tr-2006-45.pdf
    Are you aware of  FILESTREAM capabilities (since SQL Server 2008).This IMHO would be much better approach than store BLOBs in table.

    You're assuming all users have network access to the SQL server - that's not always the case.