PDA

View Full Version : VBA Code to link to Oracle



temakhafola
09-15-2017, 03:01 AM
Good Afternoon Everyone,

I would like help. I have done my VBA coding to automate my reconciliation on excel. Is there any code I can use to link my recons to Oracle database? Currently my people have to login to Oracle eBS to get reports and save them at a certain location so the macro's for reconciliations can run successfully. What I need now is to automate my login into Oracle eBS to get all the reports and save them at a certain location then my recons can run concurrently.

Your help in this regard will be highly appreciated.

Thabiso

Kenneth Hobs
09-15-2017, 09:17 AM
Welcome to the forum!

One generally uses ADO with the connection string to do that. The connection string can be found here: https://www.connectionstrings.com/oracle/

There are several ADO examples on this forum and otherwise.