append query in asp from access

[TerriL]

I have a query in access like this :\[code\]insert into table1select * from table2\[/code\]I want user to update the above query from asp web page. Table2 is a linked excel table in access where users update daily in excel.At the end of the day, I want them to update it using the asp web page into main access database into table2. I tried the code below but i got error ` An action query cannot be used as a row source'\[code\] <% set conn = create.object ("ADODB.connection") conn open "odbcconnectionname" sql = "appendquery" set rs = create.recordset ("ADODB.recordset") conn.rs sql, conn %>\[/code\]