I am using 2 ADODB connections one (cn1) to database called LAYOUTS and the other (cn2) to SHOWS.
I have access to both databases and can use the cn1.execute "SELECT * INTO [TABLE1] FROM [TABLE2]" to create a copy of a table into the same database.
How can I do the above if [TABLE2] uses cn1 (LAYOUTS) and [TABLE1] uses cn2 (SHOWS) ? Obviously the execute command is only relevant to one connection.
Can someone help?