Loading Data |
 Previous |
 Next |
You can load data into the Oracle Database XE database in the following ways:
-
Copy and paste data from a spreadsheet.
-
Upload a spreadsheet file in a delimited format (such as comma-delimited (.csv) or tab-delimited).
-
Upload a text file containing comma-delimited or tab-delimited data.
Topics:
Loading a Text File
For files less 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:
Loading an XML Document
Oracle Application Express supports XML documents adhering to the Canonical XML specification.
To load an XML document:
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:
-
On the Database Home Page, click the Utilities icon.
-
Click Data Load/Unload.
-
Click Load.
-
Click Load Spreadsheet Data.
The Load Data Wizard appears.
-
Under Load to, select either Existing table or New table.
-
Under Load from, select either Upload file or Copy and paste.
-
Follow the on-screen instructions.