sql code to post files to different webparts in a Share Point site

• Alicia Rose

  Ten Centuries

  Points: 1044

  More actions

  February 13, 2008 at 1:47 pm

  #103460

  I am looking for sql code/approach to export a text file and 2 excel works sheets(from an excel workbook) in a folder, to 3 different tables in sql server, perform data scrubbing and then export the data from all 3 tables to 3 different excel sheets and post them in 3 different web parts in a share point site.

  Mainly sql code(or any code that i can integrate with SQL Server) to post files to different web parts in a share point site is what i am looking for.

  Any sort of pointers/suggestions would be really helpful.

  Thanks & Regards,

  Alicia Rose

• Phil Factor

  SSC-Insane

  Points: 20244

  More actions

  February 18, 2008 at 2:10 am

  #779262

  Hmm. no real problems here, but quite a bit of hard slog to get everything working nicely.

  have a read of....

  http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

  ...which should give you the basics

  also my own article

  http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/

  ..which should fill in the gaps

  Best wishes,
  Phil Factor