ADO Oracle

Resolved · High Priority · Version 2010

Mon 8 Sep 2014, 16:58 Delegate 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:44 Trainer 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:47 Delegate 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:20 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips