Could someone help me with the construction of SQL to append records into a local access database from a connected database.<BR><BR>I can open a connection and retrieve records but can&#039;t work out how to append into a local table.<BR><BR>Trying sometihing like:<BR>Set wsCon = DBEngine.CreateWorkspace("ODBCWorkspace", "", "", dbUseODBC)<BR>Set dbCon = wsCon.OpenDatabase("ConDB", , , stConnect)<BR>Set cnCon = wsCon.Connections(0)<BR>stSQL="Insert Into tblTableLocal (Field1, Field2) " & _<BR> "Select FieldA, FieldB From tblConnected;"<BR>cnCon.Execute stSQL