Hello All
I have VBA code that successfully writes to an Access native table, using ADO recordset.
Using the same code to write to an identical Access table linked to Sharepoint throws Runtime error " '-2147217887 (80040e21)' The field is too small to accept the amount of data you attemptedto add. Try inserting or pasting less data." at every line where the Sharepoint field is a date.
So: the format of the Access date is rejected by Sharepoint date field. I have tried various formats of date and string: "mm/dd/yyyy", "yyyy-mm-dd". The Sharepoint column and the Access field are both set to Date (SP is Date Only; Access is Short Date).
What format of data does Sharepoint require for a successful .update to a "date only" field?
Any ideas are greatly appreciated. Thank you. KenH.
I have VBA code that successfully writes to an Access native table, using ADO recordset.
Using the same code to write to an identical Access table linked to Sharepoint throws Runtime error " '-2147217887 (80040e21)' The field is too small to accept the amount of data you attemptedto add. Try inserting or pasting less data." at every line where the Sharepoint field is a date.
So: the format of the Access date is rejected by Sharepoint date field. I have tried various formats of date and string: "mm/dd/yyyy", "yyyy-mm-dd". The Sharepoint column and the Access field are both set to Date (SP is Date Only; Access is Short Date).
What format of data does Sharepoint require for a successful .update to a "date only" field?
Any ideas are greatly appreciated. Thank you. KenH.
Last edited:
