User Input Upload to Azure DB Table

Hi All. I am building an app with the goal of having the user input / upload data (Excel, Google Sheets, Ctrl +C/V, or some other way). I will then load that data into an Azure table.

The number of rows can easily exceed 10K, so manual, hand-keying is not an option.

Is this possible? If so, how would you recommend I go about doing that? Thank you!

Feel free to point me in the direction of an existing topic if this has already been addressed.

Hey @jay_btg, you likely want to leverage a Bulk insert records Action in a GUI mode query to your MSSQL resource.

You should be able to take the data uploaded into Retool and insert it into an Azure table with this query.

Thank you Joe. Appreciate the information. I am going to try that, and this option I found in the docs. Insert CSV data into a database | Retool Docs

1 Like