Select * into Database1.tempdb.DBO.rohantemp from Database2.Dbo.Table1
I want to transfer data from one SQL server tro another both are on same n/w and reachable from one another.
this is my connection string
Set conn = CreateObject("ADODB.Connection")
conn.Open ("Driver=SQL Server;Server=" + InServer + ";UID=usr;PWD=pwd;Database=" + InDbase)