How to get oracle data directly to Excel sheet

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
sis01
Posts: 9
Joined: Thu 07 Mar 2013 16:43

How to get oracle data directly to Excel sheet

Post by 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...

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: How to get oracle data directly to Excel sheet

Post by 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/st ... t_data.htm
http://www.devart.com/dbforge/oracle/st ... d_line.htm
http://www.devart.com/dbforge/oracle/st ... export.htm

Post Reply