What is the quickest way to export an Oracle table to Excel?

Posted on 2008-10-20
Medium Priority
Last Modified: 2013-12-18
What is the quickest way to export an Oracle data table to an excel sheet using Vb.Net (2008)?  I am currently reading in one row at a time and writing it to an excel sheet using a dataset.  However, the process takes hours to run.  There are approximately 60,000 rows to export.
Question by:Cwinde01
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 13

Expert Comment

ID: 22758102
Bind your table to a datagrid or grid view
then export the datagrid or grid view to excel

Datagrid to excel

gridview to excel

Hope that helps

Author Comment

ID: 22758261
Though it appears TechTiger007 solution would work, I am looking for something that will not use a grid or require any form objects.  I have created a report engine that creates multiple excel reports using data from Oracle tables.  However one sheet on the report is a data dump into excel from an Oracle table.  An example of 1 report would be an excel workbook with a summary sheet, trended data sheet, and finally a detail sheet (data dump).  This a commad line application only, no forms.
LVL 32

Accepted Solution

awking00 earned 2000 total points
ID: 22758859
Rather than export Oracle table to excel, import Oracle table from excel. See attached.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 22759076
awking00 do you have code example that I could use in Vb.net?  I am using the excel com object.
LVL 32

Expert Comment

ID: 22760587
Sorry, I don't use Vb.net. Not sure, but perhaps by importing the table using the excel query, there is underlying vb code that is written that could be accessed. Hopefully, some vb/excel experts might better be able to help.

Expert Comment

ID: 22764962

Using TOAD or SQL Navigator (both are products of Quest)
Just right click on the query output and save as and then choose XLS File


Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question