Loading Data

Loading a Text File

You can copy and paste tab-delimited data directly into the Load Data Wizard.

To load a text file:

1. On the Workspace home page, click the Utilities icon.

2. Click Data Load/Unload.

3. Click Load.

4. Click Load Text Data.

   The Load Data Wizard appears.

5. Under Load To, select either Existing table or New table.

6. Under Load From, select either Upload file or Copy and paste.

7. Follow the on-screen instructions.

Loading Spreadsheet Data

You can load spreadsheet data by either copying and pasting text, or by loading a file.

To load spreadsheet data:

1. On the Workspace home page, click the Utilities icon.

2. Click Data Load/Unload.

3. Click Load.

4. Click Load Spreadsheet Data.

   The Load Data Wizard appears.

5. Under Load To, select either Existing table or New table.

6. Under Load From, select either Upload file or Copy and paste.

7. Follow the on-screen instructions.

Loading an XML Document

Oracle Application Express supports XML documents in Oracle's canonical XML format.

In Oracle's canonical XML format, each element represents a column value, each element is named after the column, all elements that are part of the same row are children of a <ROW> element, and all <ROW> elements are children of a <ROWSET> element.

To load an XML document:

1. On the Workspace home page, click the Utilities icon.

2. Click Data Load/Unload.

3. Click Load.

4. Click Load XML Data.

   The Load XML Data Wizard appears.

5. Follow the on-screen instructions.