vineri, 12 septembrie 2014

Import Excel data in Oracle tables using TOAD

Creation of the table:

Database >> Create >> Table >> Load Cols from File >> choose your file of choice >>  OK >> OK

Filling the table:

Schema Browser >> Tables >> Right click the table to be filled >> Import from Text, Excel or Access >> Next >> Next >> choose the file >> Next >> set some or Next >> choose the sheet (if you want two or more sheets, will import one at a time >> Next >> Execute

Enjoy!