How to get oracle data directly to Excel sheet

How to get oracle data directly to Excel sheet

Postby sis01 » Wed 27 Aug 2014 22:04

Hi all

Im using excel, Is there any way to get oracle data (using dot connect for oracle) by macro who calls a sqlscript and the rows result put on a sheet?

Thanks in advance...
sis01
 
Posts: 9
Joined: Thu 07 Mar 2013 16:43

Re: How to get oracle data directly to Excel sheet

Postby Pinturiccio » Thu 28 Aug 2014 15:30

Microsoft Excel does not support ADO.NET providers, that's why dotConnect for Oracle does not support loading data to an Excel sheet.

dbForge Studio for Oracle allows exporting data, returned by SQL queries, to Excel format. For more information, please refer to
http://www.devart.com/dbforge/oracle/studio/
http://www.devart.com/dbforge/oracle/studio/docs/how_to_export_data.htm
http://www.devart.com/dbforge/oracle/studio/docs/how_to_export_data_through_command_line.htm
http://www.devart.com/dbforge/oracle/studio/docs/saving_and_using_templates_during_data_export.htm
Pinturiccio
Devart Team
 
Posts: 1948
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle