Re: Reading from an Excel table into an Oracle table or list to use in a query
Date: Tue, 4 Mar 2014 14:37:53 +1100
Message-ID: <CAFeFPA9FgmCZvkbHgKggwB1zFJN87=cbeAsioKHMF-vytG_TkA_at_mail.gmail.com>
As you do not have access to server external tables are out. If you convert your file to insert statements you can load them into a table and use them that way. This works from anywhere I am sure some smart cookie can write a procedure to create the insert statements out of the excel file if this needs to be done regularly
Jack
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
On Tue, Mar 4, 2014 at 10:27 AM, William Threlfall < William.Threlfall_at_albertahealthservices.ca> wrote:
> *Hi experts,*
>
> *I just spent 2 hours searching online for a way to do this, without
> success. Why is this difficult? This was simple to do in FoxPro!*
>
> *Anyway, I have been given an Excel f**ile containing a list of patient
> ID**'**s, and need to extract certain lab results for those specific
> patients.*
> *The obvious way to do this would be to read the patient id**'**s into a
> list **structure **(call it PATLIST) **and then **in the query use **WHERE
> **patient_info.pat_id** IN PATLIST* *to filter the results.**
> Alternatively, I can possibly create a table calle**d PATLIST and use
> WHERE patient_info.pat_id = PATLIST.pat_id to filter the results.*
> *However, I am stuck because I can**'**t find any information on how to
> read an Excel file into an Oracle table or list structure**.*
> *I can export the Excel file into a CSV text file if necessary, but **I**
> can**'**t find a way to read a text file into an Oracle table or list
> structure either.*
>
> *Will** someone please tell me how to do this **simply and **easily? *
> *I am using SQL Developer**, connecting remotely to the database**. I**
> don**'**t have access to **do anything on **the server, and **I **don**'**t
> have any ability to do anything **that would require DBA or SysAdmin
> access.*
>
> *Cheers, - Bill.*
>
> *_______________________________________*
> *Willliam J. (Bill) Threlfall, MSc*
> Clinical Informatics Coordinator - OTTR
> Transplant Services, University of Alberta Hospital
> Alberta Health Services
> Aberhart Centre, Room 9221
> 8440 112 Street
> Edmonton, AB T6G 2B7
>
> Telephone: 780-407-6175 FAX: 780-407-8981
>
> *Alberta Health Services*
> *www.albertahealhservices.ca* <http://www.albertahealhservices.ca>
>
>
>
>
>
> * ________________________________ *
> This message and any attached documents are only for the use of the
> intended recipient(s), are confidential and may contain privileged
> information. Any unauthorized review, use, retransmission, or other
> disclosure is strictly prohibited. If you have received this message in
> error, please notify the sender immediately, and then delete the original
> message. Thank you.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 04 2014 - 04:37:53 CET