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...
How to get oracle data directly to Excel sheet
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: How to get oracle data directly to Excel sheet
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
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