tag:blogger.com,1999:blog-1271763227002553835.post7050088918348423731..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: Importing an Excel into an Oracle databaseAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-1271763227002553835.post-64189616263480925902017-07-20T08:32:20.298+02:002017-07-20T08:32:20.298+02:00Hi Moon, you could try to use the Excel file (as c...Hi Moon, you could try to use the Excel file (as csv) as an external file.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-83867467346035009242017-07-19T22:25:17.391+02:002017-07-19T22:25:17.391+02:00Hi! I have a problem related to columns in SQL Dev...Hi! I have a problem related to columns in SQL Developer whose data types are CLOB and Binary_Double. In the verify steps of importing Excel files to the table created in Oracle SQL Developer, it shows the status "Data Types CLOB, CLOB, CLOB, CLOB, CLOB, CLOB, CLOB, CLOB, CLOB, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, BINARY_DOUBLE, CLOB, CLOB, CLOB, CLOB, CLOB, CLOB, CLOB, not supported for import". Could you tell me the solution behind this as how to import the files to database? Moonhttps://www.blogger.com/profile/13233973343241187696noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-23307413754991767032013-12-05T22:58:03.743+01:002013-12-05T22:58:03.743+01:00You sir are awesome!!!!You sir are awesome!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-82763160124351693292013-05-07T22:16:24.125+02:002013-05-07T22:16:24.125+02:00Horia- I also want to thank you for posting this r...Horia- I also want to thank you for posting this reply. I had the same symptom and underlying issue. You saved me a lot of time. Thanks, ElisabethAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-33392628347766890022012-08-21T10:11:57.424+02:002012-08-21T10:11:57.424+02:00Hi Horia,
I was just setting up a testcase to atte...Hi Horia,<br />I was just setting up a testcase to attempt to reproduce the problem you encountered... I see that I can stop doing that. Thank you for posting the solution, very much appreciated.<br /><br />AlexAlex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-47474068284107634912012-08-21T09:18:04.276+02:002012-08-21T09:18:04.276+02:00Hello again! It seems that I find the solution. In...Hello again! It seems that I find the solution. In my csv file, exported from Excel, the columns were separated by ';'. After the last column, there was a ';' sign, of course. Ora Dev expected another column data after the last ';' sign and try to map the first set of data on the next line to that fake column -> error :). If I remove the last ';' in csv file, the import works. Horiahshttps://www.blogger.com/profile/11965918478821157950noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-14675292417461933712012-08-21T08:55:10.846+02:002012-08-21T08:55:10.846+02:00Hello! I have a problem... When I check the settin...Hello! I have a problem... When I check the settings with Verify parameters before import I got: Verifying if source columns have target columns mapped Failed - Source columns are mapped to a previously mapped target column. In the Column Definition panel, each of my Source Data columns is mapped to a Target Table Columns. If I you have a tip, thank you. Horiahshttps://www.blogger.com/profile/11965918478821157950noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-29914492568494049272012-02-16T16:29:28.587+01:002012-02-16T16:29:28.587+01:00you could create an external table and use MERGE t...you could create an external table and use MERGE to update/insert the content of the external table into your "real" table... at least that's what I would do.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-37536845148758783802012-02-16T14:56:49.407+01:002012-02-16T14:56:49.407+01:00How to update(not insert) data in tables using exc...How to update(not insert) data in tables using excel?<br /><br />I don't want rows to be repeated instead the specific columns should be updated..Please reply soonSujit Dashttps://www.blogger.com/profile/14067749705137277534noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-29521216442692113732011-07-17T10:35:49.056+02:002011-07-17T10:35:49.056+02:00The Excel format is quite complicated, and also va...The Excel format is quite complicated, and also varies from version to version (afaik). Unless you write code to do that for you, there is no way to do that directly in the database. The APEX Listener has functionality which allows to upload an Excel file directly into the database, you might want to check that out (http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html).Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-2026777742941191802011-07-16T15:26:40.987+02:002011-07-16T15:26:40.987+02:00nice one thanks, but is it possible to directly lo...nice one thanks, but is it possible to directly load excel sheet with date to table, instead off converting excel to CSV and oracle table?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-21663686809920443672010-07-15T19:47:34.639+02:002010-07-15T19:47:34.639+02:00Thank you for your comments, Champ! ;)
There are b...Thank you for your comments, Champ! ;)<br />There are better ways to export and import data than using an Excel... having said that, it seems you are exporting a Timestamp not a Date. In the wizard you define the target column of datatype Timestamp and set the format mask to "dd-mm-yyyy hh.mi.ss.ff9 am" and off you go.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-68342741173544560882010-07-15T16:43:15.704+02:002010-07-15T16:43:15.704+02:00I export data from one database table and try to i...I export data from one database table and try to import in another database's table. The date is always exported as something like "23-SEP-1999 12.00.00.000000000 AM". Can you please let me know what the formatting expression would be for the date at the time of importing? I have tried all possible format strings and it fails to import the date with the value formatting as I indicated before. The formatting strings that I have used are "DD-MON-RRRR HH.MI.SSXFF AM" as well as "DD-MON-RRRR HH.MI.SSXFF AM TZR".<br />Your help will be really appreciated.<br />Email me at trooptony [at the rate] yahoo [dot] comThe_Champhttps://www.blogger.com/profile/08208910267062726932noreply@blogger.com