To add multiple rows to a table using existing rows in another table, you should use: It is impossible to add multiple rows using rows of another table using a SQL command. INSERT INTO tablename1 (PKfield, field1, field2) SELECT PKID, field1, field2 FROM tablename2 ADD PKID, field1, field 2 FROM tablename2 INTO tablename1 (PKfield, field1, field2) INSERT FROM SELECT PKID, field1, field2 FROM tablename2 INTO tablename1 (PKfield, field1, field2) FROM (SELECT PKID, field1, field2 FROM tablename2) INTO tablename1 (PKfield, field1, field2)