Inserting a Word Document

• ramses2nd

  Hall of Fame

  Points: 3720

  More actions

  September 12, 2002 at 6:42 am

  #101245

  I am investigating the Possibilities of using SQL Server 2000 to store MS Word Documents. Does anyone have a simple method of inserting these documents in? ie. What synatax to use INSERT ?????

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 12, 2002 at 11:06 am

  #436402

  Easiest way is to use the ADO stream object. Search the site you should find several threads that discuss it and using BLOBS.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• muadvic

  SSC Journeyman

  Points: 85

  More actions

  September 18, 2002 at 10:09 am

  #436779

  Andy,

  can I do it using SP?

  Thanks,

  Muadvic