Devart Forums

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

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