query to update sharepoint person or group column

  • Thread starter Thread starter DrewH.
  • Start date Start date
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.
 
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
 
Back
Top