Actually I was interested in knowing how to specify the server name. Your reply does tell how to specify the database name.
The problem I have encountered is as follows: There are two servers on which copies of the same database reside. One of them is the master copy & the slave copy needs to be occasionally updated to ensure that it is in sync with the master.
When I did an "Edit Query" on a Excel cell that queried the database on the slave database, it immediately accesses the database located on the master server. I want this query to point to the slave copy.
One solution is to rename the databases. However, I felt that specifying the server name in conjunction with the database name would be a better option.