98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » ADO Oracle
ADO Oracle
Resolved · High Priority · Version 2010
Mon 8 Sep 2014, 16:58Delegate Ricardo said...
Ricardo has attended:
Excel VBA Advanced course
Access Advanced course
ADO Oracle
Hi,
I need to create a code executing a query in an Oracle server to retrieve some data.
I can do this in SQL Server by using an ADODB object, is it possible to do for Oracle? If yes could you send me an example?
Thank you in advance,
Ricardo
Tue 9 Sep 2014, 08:44Trainer Richard said...
RE: ADO Oracle
Hello Ricardo,
Hope you enjoyed your Microsoft courses with BEST Training.
Thank you for your question regarding Oracle. Unfortunately it is outside the scope of this forum at present, as we do not cover Oracle related questions. We focus on MS Office and Professional and Management subjects at present.
Sorry we could not be of more help on this.
Kind regards,
Richard
Tue 9 Sep 2014, 08:47Delegate Ricardo said...
RE: ADO Oracle
Hi Richard,
Thank you for your answer!
My mistake, but I didn't mention that I'm doing this in Excel using VBA, and my doubt is about how to use the ADODB object of VBA inside of Excel 2010 to connect and retrieve data from a Oracle server.
Thank you.
Ricardo
Thu 11 Sep 2014, 16:20Trainer Jens said...
RE: ADO Oracle
Hi Ricardo,
Thanks for the forum question.
I have added 3 links below which explain the VBA code. The first link also explain how you can query the data using SQL.
I hope this will help you in the right direction.
If you have problems with the code. Please paste the code you are using and let me have a look at it.
http://hoopercharles.wordpress.com/2009/12/02/retrieve-data-to-excel-with-a-macro-using-ado/
http://www.experts-exchange.com/Database/Oracle/Q_28029273.html
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_21751278.html
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 18 Sep 2014: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:How to Spell Check an Excel 2010 WorksheetExcel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet. |
