Step 2 – Apex Developer Day - Creating a Table from a Spreadsheet

 

To load the data for this tutorial from a spreadsheet, perform the following steps:

1.	Enter the following URL to log in to Oracle Application Express (change the <hostname> to localhost, your specific hostname or apex.oracle.com). For example http://locahost:8080/apex Or Click on APEX 3.2 link on the browser
2.	To log in to Oracle Application Express, enter the following details, and click Login. Workspace: <YourName> or Name created in Section 1 Username: <YourName> or Name created in Section 1 Password: oracle or Name created in Section 1 Remember, passwords are case sensitive in Apex by default.
3.	To create the table, click the down arrow next to Utilities > Data Load/Unload > Load.
4.	Click Load Spreadsheet Data.
5.	Ensure that the import target (Import To) is set to New table. For Import From, select the Upload file (comma separated or tab delimited) option. Click Next >.
6.	Click Browse...
7.	Locate the tasks.txt file and click Open. Because the data in the text file is tab delimited, enter \t in the Separator field. Click Next >. In this example the file is located on /home/oracle/wkdir/apexstart/tasks.txt
8.	The Table Information page displays the columns in the table and their formats, as well as the data to be inserted into the table after the table is created. For Table Name, enter APEX_TASKS, and click Next >.
9.	Using the Primary Key page, you can add a system-generated primary key to your table and populate that column with a new sequence. Review the default values, and click Load Data.
10.	After the table is created and the data is loaded, you are left on the Files page. You can see the file that you just uploaded with 16 rows successfully uploaded. To view your new table, click the SQL Workshop tab.
11.	Select the down arrow next to Object Browser > Browse > Tables.
12.	To view the table definition, click the APEX_TASKS table under the list of tables in the left navigator.
13.	This page displays the table definition. To view the data in the table, click the Data tab.
14.	You see all the data in the table. You can change any of the data in the table from this page, and also add rows to the table.