Well FWIW the documentation says to include the password and UID in all connection strings.

"All connection information, including passwords, must be provided each time OPENDATASOURCE is called."

obtained from : http://msdn2.microsoft.com/en-us/lib...5(SQL.80).aspx

It is far better to qualify the required SELECT * INTO by breaking it into a
Create Table / Insert Into method.
I also agree FWIW.
I tend to over simplify just because I will have to figure out why it didn't work 5 years from now. By then I have either advanced in my learning enough to spot it immediatly, or I will not have to break my head trying to figure out what is going on before I can find and fix the issue. Today it maybe Fred had a hangover and fat fingers, or it could be I have to deal with metric measurements in lieu of imperial. Either way it is broken out simply for maintianablity.