# zstblRemoteDataImport

UpdateSQL:
UPDATE [C:\Projects\HabiDat\Article\RemoteData.mdb].tblClient AS tblClient_1 LEFT JOIN tblClient ON (tblClient_1.ClientID = tblClient.ClientID) SET tblClient.ClientID = [tblClient_1].[ClientID], tblClient.LastName = [tblClient_1].[LastName], tblClient.FirstName = [tblClient_1].[FirstName], tblClient.DOB = [tblClient_1].[DOB], tblClient.ImportDate = Now(), tblClient.ImportBy = GetUserName_TSB();


UpdateSQL:
UPDATE [C:\Projects\HabiDat\Article\RemoteData.mdb].tblEncounter AS tblEncounter_1 LEFT JOIN tblEncounter ON (tblEncounter_1.ClientID = tblEncounter.ClientID) AND (tblEncounter_1.StartDate = tblEncounter.StartDate) AND (tblEncounter_1.ProgramID = tblEncounter.ProgramID) SET tblEncounter.ClientID = [tblEncounter_1].[ClientID], tblEncounter.StartDate = [tblEncounter_1].[StartDate], tblEncounter.ProgramID = [tblEncounter_1].[ProgramID], tblEncounter.EndDate = [tblEncounter_1].[EndDate], tblEncounter.ImportDate = Now(), tblEncounter.ImportBy = GetUserName_TSB();


UpdateSQL:
UPDATE [C:\Projects\HabiDat\Article\RemoteData.mdb].tblEncounterService AS tblEncounterService_1 LEFT JOIN tblEncounterService ON (tblEncounterService_1.ClientID = tblEncounterService.ClientID) AND (tblEncounterService_1.StartDate = tblEncounterService.StartDate) AND (tblEncounterService_1.ProgramID = tblEncounterService.ProgramID) AND (tblEncounterService_1.ServiceID = tblEncounterService.ServiceID) SET tblEncounterService.ClientID = [tblEncounterService_1].[ClientID], tblEncounterService.StartDate = [tblEncounterService_1].[StartDate], tblEncounterService.ProgramID = [tblEncounterService_1].[ProgramID], tblEncounterService.ServiceID = [tblEncounterService_1].[ServiceID], tblEncounterService.ProvidedBy = [tblEncounterService_1].[ProvidedBy], tblEncounterService.ImportDate = Now(), tblEncounterService.ImportBy = GetUserName_TSB();


