Connection string for ODBC connection to Oracle table; incl. pswd

[Kate]

I would like to execute a connection string in VBA to connect to Oracle
tables via ODBC and I would like to include the password in this string so
users aren't entering the password everytime they log on.

Does anyone know the snytax for this or something to start with? I've
experimented with something similar to establishing an ODBC connection string
to a SQL server database but am just getting nowhere.

Many thanks for any help.

Kate