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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quick Parts / SharePoint Library Update 0
How to Submit rows of a repeating table to a SharePoint list 1
No option to create a list in SharePoint Site 0
Setting column width in a table with a macro is not working 0
Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access Query to import from Sharepoint 0
sqlite-odbc write conflict 2

Top