Return
-
Title
How to import data from an Excel/Access/Text file and have Toad create the table? -
Description
How to import data from an Excel/Access/Text file and have Toad create the table.
-
Resolution
1. Select Database | Create | Create Table option from main menu and check the 'Display advanced features' box.
2. Click "Load Cols From File" button towards the bottom part of the screen.
3. Go through the Create Columns from File window to select the import file and other options. The import file must have column names as the first row/line of the file. Toad uses these column names to create the table field names. The default datatype of these fields will be VarChar2.
4. Select Database | Import | Import Table data to import the data from import file into the table.