Excel - get external data from database via ODBC?

Question

Have a query which retrieves data from Sybase when I open a workbook. But it always asks for my login details. How can I cut out this step without specifying a login id and password in the DSN definition?

Answer 1

I don't use ODBC, but you could possibly do it in code.

Open a sheet, record a new macro and do the connection process. Stop the recording and examine the code. See if you see your userid and password in the odbc commands.

If it works that way, all you have to do is protect the code.

The site below talks about connection strings and the ability to specify user id's and passwords in the open connection commands.