Jump to content

dw85745

Members
  • Posts

    14
  • Joined

  • Last visited

dw85745's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. 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)
×
×
  • Create New...