Hello,
I have read permission on two or three oracle tables that I've lined to in MS Access plus a 8 - 10 tables that are maintained in the same MS Access Dbase. I'm using Excel's table query function to open and run 12 separate queries as part of a daily reporting process - it queries the tables in access and the two or three oracle tables (Select Queries from Access) - oracles requires a separate set of credentials (although the exact same) input once for each of the queries. Anyone know a way to pass these credentials through to Oracle using VBA from Excel?
I have read permission on two or three oracle tables that I've lined to in MS Access plus a 8 - 10 tables that are maintained in the same MS Access Dbase. I'm using Excel's table query function to open and run 12 separate queries as part of a daily reporting process - it queries the tables in access and the two or three oracle tables (Select Queries from Access) - oracles requires a separate set of credentials (although the exact same) input once for each of the queries. Anyone know a way to pass these credentials through to Oracle using VBA from Excel?