Sql developer how to upload the excel sheet in Oracle table


 
Thread Tools Search this Thread
Top Forums Programming Sql developer how to upload the excel sheet in Oracle table
# 1  
Old 11-18-2014
Sql developer how to upload the excel sheet in Oracle table

I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records.
# 2  
Old 11-18-2014
Quote:
Originally Posted by ramkumar15
I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records.
Connect to the schema where you have your table to be populated.
Click on the connection name, then Tables in the left pane.
Right click on the table which you intend to populate.
Left click on Import Data... (Doing this opens up a file explorer window.)
Navigate to your Excel spreadsheet, select it and click Open.

This opens up the Data Import Wizard. Keep selecting the options you want (depending on what you have in your Excel file and what you want in the table), and clicking Next till you reach the last page.
Then click Finish.
It will then load the data from Excel spreadsheet to your database table.
This User Gave Thanks to durden_tyler For This Post:
# 3  
Old 11-19-2014
thanks durden.

Currently my date format is not accepting in my table.
In excel its there as 23-OCT-14. After importing its converted to 10/23/14.
My table accepts in this format only 23-OCT-14.
Please anyone help me out to sort this issue.
# 4  
Old 11-19-2014
Alter the date format in your spreadsheet. Right click, format cells, select 'number' under custom, in the 'type' field type yyyy/mm/dd
# 5  
Old 11-19-2014
Quote:
Originally Posted by ramkumar15
...
Currently my date format is not accepting in my table.
In excel its there as 23-OCT-14. After importing its converted to 10/23/14.
My table accepts in this format only 23-OCT-14.
...
Your issue is not clear as your statements appear to be contradictory.
Were you able to load the data?

"... is not accepting ..." => Was there a problem during load? (Oracle always returns an "ORA-" error code and message in case of problems.)

"... After importing ..." => Was the load was successful? (Partially? Completely?)

Also, what is the datatype of the column where you want to insert 23-OCT-14?
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies

2. Shell Programming and Scripting

Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)

Hi folks, I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx). Spreadsheet contains few lines of hyperlink data (pic attached). P.S. Hyperlink is behind the data and not visible in excel sheet directly. Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies

3. Programming

converting data from excel sheet to oracle using toad

guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies

4. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies

5. Programming

Help with Oracle SQL Developer - Subquery & Join will not work.

Greetings all, Hopefully there is someone out there on this forum who can help with this Oracle SQL Developer issue I have. Here is the code: CREATE OR REPLACE VIEW SALES_OVER_30000_WITH_TOTAL AS SELECT E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME, ... (2 Replies)
Discussion started by: U_C_Dispatj
2 Replies

6. Shell Programming and Scripting

HOWTO create in UNIX a Microsoft Excel-Sheet (with data from Oracle)

Hi HOWTO create in UNIX a Microsoft Excel sheet (with data from Oracle). At the moment I am making CSV files (using SQL statemens with || ';'), but search for more advanced formatting. Don't wish to use Perl. cheers (4 Replies)
Discussion started by: slashdotweenie
4 Replies

7. HP-UX

upload oracle table

am on HP-Unix and want to upload table on windows oracle from HP-Unix Thanx Swapnil (2 Replies)
Discussion started by: swapnil286
2 Replies

8. Shell Programming and Scripting

Perl sql table upload variable problem

Hi, I wrote a perl script to create and upload data to a mysql data base. Please see the script as shown below, #!/usr/bin/perl -w #Defenetion of modules use in this scrpt use CGI qw(:standard); use DBI ; my $datetable1 = `date +%Y%m%d`; my $datetable = $datetable1 ; print... (2 Replies)
Discussion started by: maheshsri
2 Replies
Login or Register to Ask a Question