I am looking for sql code to export a text file and 2 excel worksheets(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 sharepoint site.
Mainly sql code to post files to different web parts in a sharepoint site is what i am looking for.
Any sort of pointers/suggestions would be really helpfull.
Thanks & Regards,
Start Free Trial