Toad World® Forums

LOAD DATA

is it possible to do something like

CREATE TABLE tmp_x (acctcode CHAR(25));

LOAD DATA

INFILE ‘ComboCodeTab2Dec2015.csv’

INTO TABLE tmp_x

nad then use that “temp table” to update values in a DB ?

thanks

Kathryn

To import from CSV (and other formats), look at Database -> Import -> Import Table data.