Home » Developer & Programmer » Forms » how to export or import data to excel from database
how to export or import data to excel from database [message #270254] Wed, 26 September 2007 05:55 Go to next message
sathyam2627
Messages: 52
Registered: November 2006
Member
Hi to all,
This is sathya. i would like to know is there any method to export and import to excel from Oracle database.

if it exists please let me know, if possible with description.
I heard abt the builtin OLE2.OBJ_TYPE but i am not able to understand this.

Please help me regarding this

Thanks in advance

sathya
Re: how to export or import data to excel from database [message #270304 is a reply to message #270254] Wed, 26 September 2007 08:16 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Import is easy - just click "Data" -> "Import External Data".

For export, save the spreadsheet to CSV and use SQL*Loader to import into Oracle.
Re: how to export or import data to excel from database [message #270435 is a reply to message #270254] Wed, 26 September 2007 21:41 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'OBJ_TYPE excel'.

David
Previous Topic: Dynamic SQL
Next Topic: problem with a running form
Goto Forum:
  


Current Time: Sun Dec 04 02:17:31 CST 2016

Total time taken to generate the page: 0.05737 seconds