uploading excel with transposed data [message #664327] |
Wed, 12 July 2017 01:32 |
|
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.
[mod-edit: image inserted into message body by bb]
-
Attachment: sample.png
(Size: 115.35KB, Downloaded 1763 times)
[Updated on: Sun, 16 July 2017 01:56] by Moderator Report message to a moderator
|
|
|
|
Re: uploading excel with transposed data [message #664344 is a reply to message #664341] |
Wed, 12 July 2017 07:38 |
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
|
|
|