Loading Data

Loading a Text File

For files smaller than 30KB, you can copy and paste tab-delimited data directly into the Load Data Wizard. For files larger than 30KB, you must upload a separate file.

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 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.

Loading Spreadsheet Data

You can load spreadsheet data by either copying and pasting text, or by loading a file. To copy and paste text, the spreadsheet file must be less than 30KB. For files larger than 30KB, you can import the file in a delimited format (such as comma-delimited (.csv) or tab-delimited), upload the file, and then load the data into a new or existing table.

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.