Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Join table to file?

Re: Join table to file?

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 16 Nov 2005 20:48:37 -0800
Message-ID: <1132202916.385911@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US