query to update sharepoint person or group column

D

DrewH.

I'm trying copy some data from a table to another table linked to a
SharePoint list. However, I cannot figure out how to write a query that will
write correctly to the "Person or Group" column in the SharePoint table. In
table A, I have a field of the type "Text", and I need that information to go
into the Person or Group field in the table connected to SharePoint.

Additionally, I noticed that Access actually maps this column to a "Number"
type, although the data in the table is text.
 
J

Jesse McNulty

You need to use the ID of the User from the UserInfo Linked Table in access. If you do not use the ID you will get type conversion failures.

If the Linked able yo uare working with includes the People column the UserInfo linked table will automatically be linked also.

For example:
UPDATE Clients SET Clients.[in-charge] = 29
 
Top