If you want to insert data from another file into an Access database,you must use copy and paste.

Question

Quizplus · Accepted Answer

While copy and paste may work for small amounts of data or a one-time transfer, it is not the most efficient or reliable method for transferring data from another file into an Access database. A more appropriate method would be to use the import feature in Access to select and transfer the data from the file into the database.

If You Want to Insert Data from Another File into an Access