Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data and password
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data and password
The answer is yes it's possible.
If you're using Microsoft Query you may have to change the implementation to DAO. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data and password
"Alain" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
How do I get external web data that requires a password? | Excel Programming | |||
external data with a password (take 2) | Excel Programming | |||
Get external data with password | Excel Programming |