I&#039m trying to copy selected records from a table into another.<BR><BR>db_connection = "DSN=company; UID=;PWD=;"<BR>SET DbObj = Server.CreateObject("ADODB.Connection")<BR>DbObj.O pen db_connection<BR>DbObj.BeginTrans<BR><BR>SQL = "SELECT * FROM company!ordertemp WHERE Ordertemp.orderid = &#039" & strOrderID & "&#039 INTO ARRAY OrdArray"<BR>SQL2 = "INSERT INTO order FROM ARRAY OrdArray"<BR><BR>DbObj.Execute SQL<BR>DbObj.Execute SQL2<BR><BR>DbObj.CommitTrans<BR>DbObj.Close<BR>SE T DbObj = Nothing<BR><BR>----<BR>I get the Syntax Error (80040e14) when it tries to execute the second SQL statement. When I enter the statements from within Visual FoxPro into the command window it works as I want it to. I&#039ve tried using Response.Write to make sure nothing funny is going on and it looks like it should. Is there a better way to copy selected records from one table to another? Any ideas on what I did wrong? Is the Array feature supported when called from ASP?<BR><BR>Thanks<BR>Erik<BR>