Databases Reference
In-Depth Information
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
.
Figure 4-13.
Pasting the spreadsheet data into the Data text box
When you click Next, APEX parses the data you've pasted in and does its best to match the column names in the
first row of the spreadsheet data to the column names of the table into which you're loading the data. On the next
screen, you're presented with column mapping so you can check its accuracy and, if necessary, make alterations
and corrections.
APEX is very good about matching column names as defined in the spreadsheet with those that have the same
name in the table. However, if the names differ, it doesn't try to guess but instead leaves the mapping to you.
If you scroll to the right, you should see that APEX has matched all the column names from the spreadsheet
correctly to the table columns. If, for some reason, the mappings aren't right, you can adjust them using the
drop-downs shown in Figure
4-14
.
