Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Join table to file?
reuben.nantogmah_at_gmail.com wrote:
> I have an excel file containg a data set which I want to link to a
> table in oracle. Normally I would just create a table and load the data
> from excel. In this case I can't do that because I don't have create
> permission on the database. Is there a way to work around this? I'm
> using sqlplus.
>
> Thanks for your help.
>
> -R
Save it as a .CSV and then create an external table that points to it.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Nov 16 2005 - 22:48:37 CST