Embed a username and password in Excel

[Dom71555]

I would like to use Excel to connect to my MS SQL Server database to run a query that is scripted inside the Excel workbook. Is there a way that the username and password be contained in the workbook so the user does not have the connection box show? It is a generic username and password that is read only.

Thank you for your help!

 

[Andrzejek]

What is your Connection String to connect to your MS SQL Server database?
You can include the Username and Password in it.

Have fun.

---- Andy

 

[Dom71555]

Thanks Andy...
The connection string looks like this

Provider=SQLOLEDB.1;Persist Security Info=True;User ID=campusro; (just a sample )

I am not sure how to get the password in there. What is the correct syntax for the password? User ID=campusro...what would the password entry look like?

 

[Andrzejek]

You mat try:
Provider=SQLOLEDB.1;Persist Security Info=True;[blue]UID=campusro;PWD=abcxyz"[/blue]

You may find more examples of connection strings here

Have fun.

---- Andy