Copying rows from one Access database to Another using Query
In access database, we can copy rows from one table to another using query. How can we transfer rows from one database to another? Using the in keyword in Insert statement we can specify an external database path as follows in access query insert into Account_Transactions(Date ,Name ,Type ) in 'D:\Sherpharma\T.mdb' select Account_Transactions.Date,Account_Transactions.Name,Account_Transactions.Type from Account_Transactions Here we copy the rows from current database to the T.mdb files. We can also use this query in programming as well.