Home » SQL & PL/SQL » SQL & PL/SQL » uploading excel with transposed data
uploading excel with transposed data [message #664327] Wed, 12 July 2017 01:32 Go to next message
oracbeg
Messages: 16
Registered: July 2017
Junior Member
Hi everyone. I need help with excel upload to oracle table. Actually i want to upload an excel in oracle table but it is in transposed form. the excel rows in the left are to be columns in the table and corresponding are the values of it in form of rows in excel. Is there any way to upload that excel in oracle table without transposing or doing formatting in that excel.

Please help

I have attached screenshot to understand better where in the left are the columns and in right is the rows data.

/forum/fa/13578/0/

[mod-edit: image inserted into message body by bb]
  • Attachment: sample.png
    (Size: 115.35KB, Downloaded 1504 times)

[Updated on: Sun, 16 July 2017 01:56] by Moderator

Report message to a moderator

Re: uploading excel with transposed data [message #664341 is a reply to message #664327] Wed, 12 July 2017 06:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Re: uploading excel with transposed data [message #664344 is a reply to message #664341] Wed, 12 July 2017 07:38 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
If you don't have a tool that allows you to directly load from an excel file like TOAD then the simplest way is to save the excel as a CSV file and then use an external table or sqlldr to load it into the table. Neither cars about the order of the columns
Previous Topic: How to retrieve negative value as positive in simple brackets?
Next Topic: Merging of Interval Partitions
Goto Forum:
  


Current Time: Thu Mar 28 09:58:33 CDT 2024