How can I copy the contents of one MS Access table to another using ASP by VB Script?

Code required, Thanks.How can I copy the contents of one MS Access table to another using ASP by VB Script?
eg. if you want to pass all data of table1 to table2 from asp page.





use select command in asp script





eg.





select * into table2 from table1





this will insert all records of table1 into table2





kshitij yelkarHow can I copy the contents of one MS Access table to another using ASP by VB Script?
1. Create a database connection


2. Execute SELECT INTO command