External data and password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
The answer is yes it's possible.

If you're using Microsoft Query you may have to change the
implementation to DAO.
 
Alain said:
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
Click to expand...


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
 
Back
Top