Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing Excel File to Oracle Table using SQl Plus

Muhammad Azeem AhmadJun 7 2019 — edited Jun 10 2019

Hi All,

I am trying to import an excel sheet exported from SQL Server database to Oracle table using the SQL Plus Import Data Tool:

All the rows get successfully imported except the date time columns/rows i tried to specify the date time format while import but nothing works, attached are few rows from excel file which needs to be imported also attached is the screenshot of the date format i tried but ended up in errors:

Please download the excel from this link::

https://www.dropbox.com/s/9ek7ty90wdc1das/Share.xlsx?dl=0

1.png

Comments
Post Details
Added on Jun 7 2019
7 comments
4,266 views