Finally. Found it easier to use the ConnectionString Property as an INI read rather than concatenating variables, as I kept getting as server connection error. Now, the next task is to have the bulk copy accept a parameter. If I use a WHERE clause in my SQL string I get an error. I think this will require going to a command object and setting parameters, but I'll look around.
Just have to say, even though I'm making some pretty sophomoric mistakes in coding, this is exciting stuff. I'm not ready to let go of COM [and besides it is all the same].... :D :D :D