Hello,
i am using the code to insert values from the temp table to the main table. i
only want to transfer all the records where email and userid is not null....
CurrentDb.Execute "INSERT INTO LDAPUserList L
(L.FullUserName,L.FirstName,L.LastName,L.Initial,L.UserID,L.Email,L.UserFolder,L.WorkOffline)
VALUES SELECT
LDAPUserListTemp.FullUserName,LDAPUserListTemp.FirstName,LDAPUserListTemp.LastName,LDAPUserListTemp.Initial,LDAPUserListTemp.UserID,LDAPUserListTemp.Email,LDAPUserListTemp.UserFolder,LDAPUserListTemp.WorkOffline
FROM LDAPUserListTemp WHERE LDAPUserListTemp.UserID Is Not NULL OR
LDAPUserListTemp.Email Is Not Null"
not sure why it doesn't work.
please help!!!
thanks,
lyanne
L y a n n e R h e e z a C. O n g
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
