Home » Developer & Programmer » Forms » HOW TO EXPORT RECORDS FROM EXCEL TO ORACLE?
HOW TO EXPORT RECORDS FROM EXCEL TO ORACLE? [message #85942] Sun, 15 August 2004 17:30 Go to next message
Dhalan
Messages: 15
Registered: August 2004
Junior Member
IS THERE a way to export any records from excel to oracle? thankss....

Report message to a moderator

Re: HOW TO EXPORT RECORDS FROM EXCEL TO ORACLE? [message #85946 is a reply to message #85942] Sun, 15 August 2004 22:37 Go to previous messageGo to next message
Robin ( Bangladesh)
Messages: 25
Registered: September 2002
Junior Member
Excel to text file then text to oracle, SQL loder may be used?

Report message to a moderator

Re: HOW TO EXPORT RECORDS FROM EXCEL TO ORACLE? [message #85979 is a reply to message #85942] Wed, 18 August 2004 20:13 Go to previous message
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
Member
Hi Dhalan

There is one more very simple way.
Just copy your Excel contents into Microsoft Acces table (Make one with kinda same structure)

Then with This Access Table.
Go to File -> Get External Data -> Link tables
After linking successfully with Oracle using ODBC Driver now you can just copy from Access and Pasting same in Link table would commit data directly in Oracle.

It sounds lenghty but try once you willstart loving it.

Cheers
Atul P

Report message to a moderator

Previous Topic: How to show total no of users using the application
Next Topic: what is the relation LOV Query with the master key?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 07 15:54:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.