To get started heres one for transferring from a Foreign Db to the Current DB that took me a day to figure out. strSQL = "INSERT INTO " & strDestTBLName & "" _ & " SELECT * " _ & "FROM " & strScrTBLName & "" _ & " IN '" & strScrPathDB & "';" '<<Note use of single quotes required around strScrPathDB ' Debug.Print strSQL DaoDb.Execute strSQL, dbFailOnError '<<Execute belongs to DaoDB (Destination DB)