• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Export Query to Excel for ORACLE

 
sudha swami
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I would like to Export the result of sql query into Excel.
regards
sudha
[ September 18, 2007: Message edited by: sudha swami ]
 
Scott Selikoff
author
Saloon Keeper
Posts: 4011
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A lot of GUI applications will allow you to cut and paste data into Excel but from a programmatic standpoint, its best to write a java program that converts the result set into a CSV file (just fields separated by commas) and import that into excel.

You could also try GUI tools for exporting your database directly into a CSV file.
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
See if the POI Library does what you need. I've only used it to read excel but it worked easily enough.
 
sudha swami
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thanks alot for the info. Currently i am using GUI Tool, DBVisualizer and it supports exporting the data into CSV
sudha
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic