SQL

Hi Tim. That depends a lot on the SQL server you're linking to. It is possible to write code which will detect password forms and automatically fill them with the correct login information, but this would be a time-intensive project to simply avoid a login dialog. On the other hand, incorporating passwords when contacting SQL servers is a security issue and will necessarily slow the connection process so it's something we all have to live with, unfortunately! The password setup will obviously be within the SQL software rather than in Excel, as Excel in this case is the "front end" of the process, with the server operating in the background.

Hope this helps,

Anthony