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

Home -> Community -> Usenet -> c.d.o.server -> Re: Connecting excel ro oracle database

Re: Connecting excel ro oracle database

From: RK <rajXesh_at_hotmail.com>
Date: 17 Jul 2002 06:51:54 -0700
Message-ID: <548b9514.0207170551.76a5d246@posting.google.com> 





"DA" <amunwa_at_hotmail.com> wrote in message news:<1026651306.99086_at_cache2>...


> ...can anybody tell me how to connect an excel spreadsheet to an oracle

> database...

> 

> thxs in advance




Look into creating a table in Oracle with ORGANIZATION EXTERNAL 



http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/statements_73a.htm#2093662



You would probably have to save the Excel spreadsheet as CSV




Received on Wed Jul 17 2002 - 08:51:54 CDT












Original text of this message













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