Asp Conection
i'm trying to add a recordet to another and i'm using this code
Code:
sql1="select * INTO final from ftemp "
Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("/test.mdb")
Conn.Open DSNName
RS.open sql1, Conn,3,3
but i get this response
Code:
Table 'final' already exists.
can any tell me the missing code?