How do I select an entire table and insert it in a new table which exists in a different database?


I'm trying to export a table from ACCESS file to Oracle Table using VB recordset but I don't want to loop in a recordset , I just want to INSERT the entire table

Is thie possible ?