Upon syncing an Excel worksheet with a database table, I would like to present the user the capability to not only INSERT and UPDATE the records in the database table, but also to DELETE the records that are present in the database table, but not in the Excel file (based on the primary key, or unique identifiers).
This could be through a configuration parameter or on a "per-table" possibility. (So a checkbox when syncing the table).
This could be through a configuration parameter or on a "per-table" possibility. (So a checkbox when syncing the table).
Upvote
0