Link to home
Start Free TrialLog in
Avatar of NiceMan331
NiceMan331

asked on

exporting data to excell sheet from oracle form

hi
any one can provide an example on how to export data from oracle form to excell sheet
Avatar of Steve Wales
Steve Wales
Flag of United States of America image

How much data and how many tables are you talking about ?

If it's a relatively small amount of data / tables, you can define an ODBC connection to the database, launch Excel and import via MSQuery.

I believe SQL Developer (free, from Oracle) can export results to a spreadsheet too.

There are also paid product solutions.

I use PL/SQL developer (Allround Automations is the developer)
TOAD (from Quest / Dell) can probably do something similar too.
Agree with Steve Wales.

SQL Developer is free and can suffice your need. Toad does the same job, but it is paid.
Avatar of NiceMan331
NiceMan331

ASKER

thanx to all
but i'm speaking about users of my forms , i need them to be easy send data for the current record to ms excell , not to going to toad or sql developper where they don't have any experiance with
the data to be exported is a very few , may not more than 50 records per time
look the definition of the tables
here
ASKER CERTIFIED SOLUTION
Avatar of regmigrant
regmigrant
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
there is no direct export to excell ?
Excel is a complex format, the simplest way to move data is with text, Forms themselves only have exports provided by the person who develops them
ok thanx