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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics