How to export the excel file in oracle

5 pts.
Tags:
Microsoft Windows XP
Oracle
Oracle 10g
Oracle 10g administration
how to export the excel file in oracle

Software/Hardware used:
oracle 10g,windows xp

Answer Wiki

Thanks. We'll let you know when a new response is added.

U can make a text file, (creating with comma separated) from excel and then load the data in the text file into oracle using sqlldr (sql loader).

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    The above answer would be correct if what you want is to IMPORT the file into the database. If you want to EXPORT data to an excel file, I don't think there is a native way to do it directly from the database. You could, however, write the data to a CSV file to open it with Excel.
    69,835 pointsBadges:
    report
  • Subhendu Sen
    Answered by Carlosdl, You could, however, write the data to a CSV file to open it with Excel. It is bit difficult and there r some procedures.... A flat file pipe-delimited & it is easily to get it into oracle. The application will read the file and convert the data to SQL INSERT statements so that it can be run as a script. The "SQL INSERTS" have been designed to work with Oracle database. The code could easily be modified to work with any SQL compatible database. As far as my knowledge, there may be some problem with date/time fields also, if u r using CSV format. U may go for as I written earlier, as it is easy than to write data in CSV file.... U can use a 3rd party convert tool for this works. For Convert Tool please visit HERE But I never use it and it is free. So, if u wish to use this, please check in all respect before using it. Thanks--
    28,890 pointsBadges:
    report
  • Chippy088
    I am not sure if you want to export to excel from oracle, or export the excel data to oracle. My answer is assuming you want to export from oracle using excel. I use excel often to import data. What you need to do is create an ODBC connection to your database. Then use it to import the data. I am working with a colleague who looked over my shoulder as I was answering this, and he thinks you can do it with the spool function from the oracle prompt as well. He suggests something like this. set feed off markup html on spool on spool c:yourexcel.xls select * from yourexcel; spool off set markup html off spool off I have added this, as he is quite knowledgeable (more than me) with oracle. Maybe you understand it, (I have to admin I don't even though he explained it) hope it helps.
    4,625 pointsBadges:
    report
  • jkeri
    you can also convert it to a TEXT file and then using Forms10g and UTIL_FILE, populate a table with it. I have done it and it works great.
    360 pointsBadges:
    report
  • jkeri
    One way i did it was to use forms10g to call a reports10g. the report had the account for the rows i needed in the Excel file. My forms10g used the SET_REPORT_OBJECT_PROPERTY (v_rep_id,REPORT_DESFORMAT,'DELIMITEDDATA') and the SET_REPORT_OBJECT_PROPERT(v_rep_id,REPORT_DESNAME,'C:datadirectoryfilename.csv'); This created a file with the .CSV extension that was easily imported into Excel
    360 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following