How to Export/Import Table Using Toad
–
On the Schema browser select the table
–
Right click on the table and select
“Export Data”
–
Set the output file format and path and set
the data substitution as per the requirement.
–
Same as the export to import data either
right click on selected table and select “import data” or from the database
menu select import->import Table data.
–
After setting proper schema/object/object
to be import press “Next”
–
Now select the source file type (either
Excel/Text/DBF) and file location.
First Row: 2 ignore the first
row in the excel i.e column heading.
Last row: 18000 maximum limit
of row to be imported.
Same as you can set the
date/time and number
–
In the “Next” Click it prompts to
indicate column mapping from source to destination.
–
Verify the mapping and press OK.
