Database Reference
In-Depth Information
Figure 4-11.
Preparing to copy and paste the spreadsheet data and load it into the exist-
ing 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.
Figure 4-12.
Enter the name of the table into which you're going to load the data
8.
Paste the data that you copied to the clipboard in step 2 into the
Data
text
area, and ensure that
First row contains column names
box is checked, as
shown in
Figure 4-13
. Click
Next
.