Once you have created a custom Oracle Table, you can also import data directly to the new Table (before creating a custom Data Entry Page) to populate the table from an existing Excel spreadsheet.
Using the Manage Tables option, locate the table you wish
to populate and then click the Import Data option on the far right hand
column:
You will be prompted to select an Excel file from your computer; use the Browse key to locate the file and once you find it, click Upload to begin the import.
Alternatively, you can simply drag & drop the file to the white space on the import wizard.
Note: It is important that the excel file be closed for the import to be successful.
