Skip to main content

Save data to database

If you have permissions to save to your database, then look after Save To Database menu items.

Save To Database dialog will allow you to map data from the grid and merge it to the database table.

First of all, you can't modify SQL table without primary

Merge data

A Worksheets Data Studio uses SQL MERGE (also called upsert) statements to INSERT new records or UPDATE existing records depending on PRIMARY KEYS in the target table.