Toad World® Forums

Import data from 2 different excel files

Hi ,
I have a table created and want to load data into that. I have imported 6(of 8) columns from one excel file and now I have to import data into other 2 columns from a different file. Is it possible in Toad? Can anyone please let me know the way it should be implemented.

assuming you have the key for the rows in both excel files, you can set the data import mode to ‘update’. you just have to indicate what column is the key when you get to that screen in the wizard.

if you don’t have the key on the 2nd excel file i don’t know how you’d guarantee the correct rows get joined together.