sql server password entry during macro run
 

i have an excel worksheet which is a straight link from an access query, this
works fine but when i come to refresh my data in the excel sheet i get asked
for the "sql server Login password" my user name is there by default and i
would like to insert the password automatically as im running a macro to
automatically refresh the data. is there some code to insert this password
automatically?