Re: Reading from an Excel table into an Oracle table or list to use in a query

  • From: Karth Panchan <keyantech@xxxxxxxxx>
  • To: "William.Threlfall@xxxxxxxxxxxxxxxxxxxxxxxx" <William.Threlfall@xxxxxxxxxxxxxxxxxxxxxxxx>
  • Date: Mon, 3 Mar 2014 18:58:51 -0500

Bill

You can use SQL Load utility or External tables from Oracle. 

SQL Load allows you define control file with your CSV fields and delimiter. 
Then load to table. 

HTH
Karth

Sent from my IPhone 

> On Mar 3, 2014, at 6:27 PM, William Threlfall 
> <William.Threlfall@xxxxxxxxxxxxxxxxxxxxxxxx> 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 file 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 called 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
>  
>  
>  
>  
> 
>   ________________________________
> 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.

Other related posts: