External data and password

[Alain]

I have a workbook that extract data from an external SQL server from an ODBC
connection. Everytime I need to refresh the data, it is asking for a password
It is possible to VBA some code to automate the SQL server login from being
prompted every time we refresh the data

Thanks

 

[gimme_this_gimme_that]

The answer is yes it's possible.

If you're using Microsoft Query you may have to change the
implementation to DAO.

 

[Carl Irving]

I have a workbook that extract data from an external SQL server from an ODBC
connection. Everytime I need to refresh the data, it is asking for a password
It is possible to VBA some code to automate the SQL server login from being
prompted every time we refresh the data

Thanks

Hi Alain

did you ever get this to work, i have exactly the same problem, but my
external data is in microsoft access and not in microsoft query, so just
wondering how you achived it in the end