how to insert several rows at once into a table

[Guest]

I need a short cut to insert several rows at one go into a table

 

[Arvin Meyer [MVP]]

I need a short cut to insert several rows at one go into a table

You might try an Append or Insert query, something like:

INSERT INTO tblMyTable
SELECT *
FROM tblMyOtherTable;