Upload CSV then insert values

[Jon]

Hello all,

Just wondering if the below is possible and if so, the best approach.

I'd like to give a user the ability to upload a CSV file (either as a
blob or a file on the system), then for the contents to be inserted
into an Oracle table.

Any advice, etc would be great.

Thanks,

Jon

 

[David]

Yes, very easy.

1. Upload the file onto the server hard disk.
2. Use ODBC to open the CSV. You can do "select * from [csvfilename.csv]"
(the [ and ] are required).
3. Loop through, inserting rows into your database.

--
Best regards,
Dave Colliver.
http://www.AshfieldFOCUS.com
~~
http://www.FOCUSPortals.com - Local franchises available