Re: [MSAccessProfessionals] Export to Sharepoint

I have deploy in production a ms access app with a SharePoint back end. I have just created an append query with a trigger macro and it works exactytje same as it would with a jet database 

On Thu, 25 Jan 2024, 3:48 am Jim Wagner, <josephwagner2@outlook.com> wrote:

Hello all,

I have successfully created some code to export a table to a sharepoint list. The code creates a new copy of the sharepoint list each day. My boss created a power flow to delete the list each morning. But my boss wants to have the list be appended from the table instead of a new list created. He says the new list breaks any links to other objects. is there a way to do an append to a list instead of a create list? Below is my code without the sharepoint site for security reasons.
Thank You So Much for your assistance with this

Jim Wagner

DoCmd.TransferDatabase acExport, "WSS", "https://****************************************", acTable, "R&D-Vacant Positions STAR", "Vacant Positions", False
DoCmd.TransferDatabase acExport, "WSS", "https://****************************************", acTable, "R&D-CURRENTEMPLOYEES", "CURRENT EMPLOYEES", False
DoCmd.TransferDatabase acExport, "WSS", "https://https://****************************************", acTable,, "All R&D-EMPLOYEEHistory", "EMPLOYEEHISTORY", False
DoCmd.TransferDatabase acExport, "WSS", "https://****************************************", acTable, "R&D-ACCRUALS", "ACCRUALS", False
DoCmd.TransferDatabase acExport, "WSS", "https://https://****************************************", acTable, "TemporaryEmployees", "TEMPORARYEMPLOYEES", False
DoCmd.TransferDatabase acExport, "WSS", "https://https://****************************************", acTable, "TemporaryEmployeesTerm", "TEMPORARYEMPLOYEESTERM", False

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116525) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_