Hi Team,
How can i insert the data from excel sheet to SQL table using forms upload option.
Thanks
Shubham Jain
Hi Team,
How can i insert the data from excel sheet to SQL table using forms upload option.
Thanks
Shubham Jain
I believe the only option is to have the form save the upload to the repository and either call a workflow from Forms after the upload or have Workflow monitor the folder for new uploads.
Then you should be able to use workflow to export the Excel file to a specific location with a specific file name. Finally use an ODBC connection with a Query Data activity or use a Custom Query activity with OPENROWSET.
See How to import CSV into SQL with Workflow for an example of exporting the file to a windows folder and how to use the SQL OPENROWSET function. Note the the sample shown in the link is for CSV, but you can do a web search for how to use it with Excel.
See Reading from Excel file for an example of using a Query Data activity to query an exported Excel file.