-
VBA Code to link to Oracle
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules