To paste tabular data from clipboard to editable dataset in Database Tour:
- Open the database.
- Open your dataset, i.e. select a table from the table list or execute a SQL query.
- If you chose the table, switch to Data page. Make sure the Allow Edit button is pressed.
- If you chose the SQL query, make sure the query result set is editable.
- Select a cell in the data grid, from which you wish to paste data, and press CTRL+ALT+V.
.png)
CTRL+ALT+V
.png)
Notes
- Clipboard data should be delimited by TAB and CR/LF. For example, when you copy a cell range in Excel, this condition is met.
- The data is pasted either to empty data set (INSERT) or to existing records of non-empty data set (UPDATE). In the latter case, data is pasted from current record to the last record in the table or until the last record in the clipboard, depending on which count is less. During UPDATE, if the last table record was reached, but more rows exist in clipboard, they are appended (inserted) to the table.
- If clipboard contains more than one record, it is not recommended to paste data from it, if target data set is not empty and sorted or filtered and sort or filter condition contains the field you want to update. For example, when posting a record from the clipboard into sorted data set, the position of the current record can be changed according to current sort order, therefore the next record can be placed in wrong place (record) of the target data set.
See also
