Forum Discussion
I want to explore the possibilities of updating SQL table with Microsoft form whenever a response is
We are having a SQL table in which our daily factory production details will be uploaded, now we want to automatically update of that table with details submitted via Microsoft Forms. Please suggest ...
You can achieve the same via many ways.
One of them could be -
1. Create a new Microsoft Form to collect the necessary production details.
2. Create a new Excel spreadsheet and link it to the Microsoft Form to store the submitted data.
3. Connect to the Excel spreadsheet as a data source in your SQL Server.
4. Create a SQL Server Integration Services (SSIS) package to extract data from the Excel spreadsheet and load it into the SQL table.
Let me know if it suits your requirement. If you are satisfied with the answer hit like button.
One of them could be -
1. Create a new Microsoft Form to collect the necessary production details.
2. Create a new Excel spreadsheet and link it to the Microsoft Form to store the submitted data.
3. Connect to the Excel spreadsheet as a data source in your SQL Server.
4. Create a SQL Server Integration Services (SSIS) package to extract data from the Excel spreadsheet and load it into the SQL table.
Let me know if it suits your requirement. If you are satisfied with the answer hit like button.