I have an Access database with linked Oracle tables. I am opening my Access query in Excel and need a way to hardcode the Oracle ODBC password into my connection string. Since I'm initially connecting Excel to Access just through the Excel connection wizard, I can only see the Access db information in the connection string so I am always getting the login prompt for the Oracle tables when I open the spreadsheet to refresh the data.



Is there somewhere to hardcode the Oracle password into my Excel connection?

Thanks,

Toni