Скопировать таблицу

using System;
using System.Data.OleDb;

namespace ConsoleApplication1
{
	class Class1
	{
		[STAThread]
		static void Main(string[] args)
		{
			OleDbConnection _cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=db1.mdb");
			OleDbCommand _cm = new OleDbCommand(@"SELECT Table1.Field1, Table1.Field2 INTO Table2 IN 'db2.mdb'FROM Table1;", _cn);
			_cn.Open();
			_cm.ExecuteNonQuery();
			_cm.Dispose();
		}
	}
}