Issue With Import Data to Sharepoint

[srikanthbenonimv]

Hi -

I have a Linked Table in Access "LinkCalc" and I have exported table from Sharepoint as "Calc" am try to import data from LinkCalc to Calc however am getting an error message as "An INSERT INTO Query cannot contain a multivalued field". I have created Append Query to add records into Calc which is a sharepoint list. Need help to resolve it.

 

[almahmood]

Hi,

The issue described itself. You cannot run an INSERT query with containing a multivalue field. The table has one or more multivalue fields. If you just ignore them in your INSERT query, you will be fine. This is nothing related to Sharepoint I believe.

You can update multivalue field using Recodset.