Quiero hacer INSERT en un Recordset de una Tabla SQL Server, pero de un select de un Recordset Acces
¿Como los Junto?
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ("f:\Quest\database\data.mdb")
Set cnn = Server.CreateObject ("ADODB.Connection")
Cnn.Mode = adModeRead
Cnn.Open strCnn
set Rst = Cnn.Execute ("SELECT * FROM tblLog")
If Not Rst.EOF then
Dim CnnSQL, RsSQL
Set CnnSQL=Server.CreateObject("ADODB.Connection")
CnnSQL.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=;Initial Catalog=emanagement;Data Source=eServer"
Set Rst = Cnn.Execute ("INSERT INTO tblLog * FROM ?? del Rst Acces???")
else
Response.Write "No Hay registros"
Rst.Close
Set Rst = Nothing
end if
