Avatar of paultran00
paultran00
Flag for United States of America asked on

Use sharepoint to collect data from internal users and external vendor

Here’s what I am trying to accomplish:

1a. Internal (REQUESTOR) user submits a form and I need to save the data into SQL SERVER.   (I was thinking of using Sharepoint).
SQL SERVER needs to extract the record (and a unique key field) that the REQUESTOR submitted and export to an Excel form (populate the top half with values from SQL) then send that Excel form (the vendor needs to fill out the bottom of of the form) to an external vendor via email.

1b. NOTE: When a form is submitted into Sharepoint's SQL DATABASE, I want a copy of the record saved to my SQL database.  How do we do this?

2. The vendor (RESPONDER) fills out the Excel form and emails back to my mailbox.
I want to take the Excel that I received via email and update that same record (unique key field) in SQL SERVER via sharepoint.


I only have a SQL SERVER 2008 R2 so I can create a table to store the data received.  I have Sharepoint 2007.
Please provide a step-by-step how to accomplish these items.

Thanks.
SQLMicrosoft SharePoint

Avatar of undefined
Last Comment
Walter Curtis

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Mohit Nair

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Walter Curtis

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Walter Curtis

Information provided is accurate and correct.
Your help has saved me hundreds of hours of internet surfing.
fblack61