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]

Re: Upload CSV then insert values

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


"Jon" <JonMYates@gmai l.comwrote in message
news:1177497092 .853462.104570@ b40g2000prd.goo glegroups.com.. .

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
>