It would be helpful if there were a tool for inserting Excel data into an existing table, instead of creating a new table.
Scenario: I have a spreadsheet that comes from the same source as when I first created an existing table. After making some manual changes to the spreadsheet, I want to load it into the existing table.
I imagine I could create a model or Python script that would:
- Create a new/temporary table from Excel.
- Append the rows from the temporary table into the existing table.
- Delete the temporary table.
But I think it would be simpler to have an OOTB tool for this.