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

Report message to a moderator

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: 4595
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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'OBJ_TYPE excel'.

David

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 10 14:19:35 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.