Can't append column to Sharepoint list using Access
Hi,
I need help with append a column from Access. The situation is I have a link table from Sharepoint and another in Access. I tried to write an append query to load a new column data to the Sharepoint list where AgentID in Sharepoint list
= to AgentID in Access table. I got Validations Violations error and none of the new data get update. The field is date/time on both, tried set field as text also doesn't work
Here's the query:
INSERT INTO [Test List] ( [Sales Generated] )
SELECT Sheet2.[Sales Generated]
FROM [Test List] INNER JOIN Sheet2 ON [Test List].[Agent ID] = Sheet2.[Agent ID];
April 30th, 2010 6:24pm