upload file and insert the data
518011Jun 27 2006 — edited Jun 28 2006I am trying to create the process to allow the user to upload a spreadsheet or .CSV and then insert the data contained within the file into the database. I used the upload and download example in the 2 day guide as the basis for the page. The data files are between 1.5 and 3MB. Following the How-To guide my DDL removes the old tables, sequences,... and creates new ones. How do would I create the procedure if it doesn't contain lookup tables or number to char conversions. Also, are there any restrictions on the file size like in import/export data(30KB)