Since Version 4.0, APEX offers the possibility to create a Data Upload wizard. This wizard is actually a visual representation of SQL Loader. But now you can import data from spreadsheets in a user-friendly way. In this recipe we will show you how easy and powerful this Data Upload wizard can be. We will create a page where a user can upload dealer address data.
Make sure you have access to the
app_dealers table and that you have an
.csv file and an .
xls file with the following layout:
DLR_NAME DLR_ADDRESS DLR_CITY DLR_STATE DLR_COUNTRY_CD
We enclosed two sample files along with this book.