Databases Reference
In-Depth Information
Figure 4-10.
Spreadsheet data from the TICKETS tab of your Excel workbook
Once you have the TICKETS data in the clipboard, you can switch back to APEX and use the Data Load
Wizard to insert this data into your
TICKETS
table. Here are the steps to follow to load data from the spreadsheet into
the database:
Locate the
helpdesk_spreadsheet.xls
file where you downloaded the supporting files for
this topic, and open it with Microsoft Excel. Navigate to the TICKETS tab. Notice that you
have a row for each ticket and a header row that contains the column headings for each of
the columns.
1.
2.
Select all the data, including the column headings, and copy it to the clipboard. Be
cautious not to accidentally select any rows that don't have data in them, because that may
cause phantom rows or errors in the Data Load Wizard.
3.
Switch back to your web browser, and, using the pull-down menu on the SQL Workshop
tab, select
Data Workshop
.
4.
In the
Data Load
region, click
Spreadsheet Data
. You should see the Load Data dialog
shown in Figure
4-11
.
Figure 4-11.
Preparing to copy and paste the spreadsheet data and load it into the existing
TICKETS
table
5.
In the wizard, select
Existing table
for
Load To
and
Copy and paste
for
Load From
, and
click
Next
.
6.
Select your “parse as”
Schema
from the
Schema
select list. This is the same schema in
which you created your tables in the Object Browser.
7.
Select
TICKETS
for the
Table Name
, as shown in Figure
4-12
, and click
Next
. This is the
table into which you'll load the TICKETS data.