Toad World® Forums

Pasting partial column into Schema Browser/data tab?


Is it possible to paste values into the Data tab on the Schema browser, for example from Excel?

I’ve heard tell of a column mode paste but cannot seem to find anything related to it. I have a lot of columns with Y/N variables that I need to toggle while leaving other cells in the column alone, and I’ve got to believe there’s a simpler way than doing it by hand, cell by cell or with insert statements.

I’m using toad v

Reference to Column Mode Paste post


If there is anything in your Excel file that can be used as a key field to match up with the rows in the table, then you can use the Database -> Import -> Import Table Data. Just identify the key field and the field(s) to import, and change the import mode to “Update”