Data+Load

this may take some tweaking . . . Please be patiente

 * 1) Download [|carsScript.docx] file into the same folder as the excel file
 * 2) Run the merge
 * 3) When you open the file it will ask you for the data set. You need to pick your cars Excel File
 * 4) Click on Mailings
 * 5) Click on Finish and Merge
 * 6) Click on Edit Individual Documents
 * 7) Load the data into Oracle
 * 8) Go into APEX
 * 9) Click on SQL Workshop
 * 10) Click on SQL Scripts
 * 11) Click on Create
 * 12) Call the Script //Cars Loader//
 * 13) Copy and Paste your mail merge results into the script
 * 14) Click Save
 * 15) Click on your Script again
 * 16) Click Run
 * 17) Click on see results
 * 18) Call me over
 * 19) If your load wasn't successful successful (some rows had errors)
 * 20) Go to SQL Commands and type TRUNCATE TABLE cars
 * 21) Close all the Word documents
 * 22) Fix the rows that it tells you in the Excel file (the numbers may not match up pefectly)
 * 23) And go back to step 2
 * 24) Lather rinse repeat until your data loads without error