Toad World® Forums

Pasting partial column into Schema Browser/data tab?

Hi,

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 10.6.1.3.

Reference to Column Mode Paste post

http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25126

Thanks!

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”