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 a 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.