Re: [MSAccessProfessionals] Export to Sharepoint

Yes, I noticed the sharepoint list has 3 extra columns not in the source that has the data to append. can i add those fields in the query designer. But nothing happens when i run the append query

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom <duanehookom@hotmail.com>
Sent: Wednesday, January 24, 2024 2:54 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Export to Sharepoint

 

Do you get an error message? I seem to recall editing and appending to a share point list that was linked to Access. There are typically a number of extra columns that might need to be considered. 

Duane

Sent from my mobile

On Jan 24, 2024, at 3:49 PM, Jim Wagner <josephwagner2@outlook.com> wrote:



Paul,

I can run a delete query and it works. But appending does not append the records

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner <josephwagner2@outlook.com>
Sent: Wednesday, January 24, 2024 2:25 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Export to Sharepoint

 

Paul,

I can give it a try. I have heard of linking to a list in SharePoint but never tried.

Thank You

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Paul Baldy <Pbaldy@gmail.com>
Sent: Wednesday, January 24, 2024 1:02 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Export to Sharepoint

 

I have zero experience with Sharepoint, but I know you can link to a Sharepoint list from Access.  Can you do that and append the data via an append query instead of TransferDatabase? 

------ Original Message ------

From: "Jim Wagner" <josephwagner2@outlook.com>

To: MSAccessProfessionals@groups.io

Sent: 1/24/2024 11:48:44 AM

Subject: [MSAccessProfessionals] Export to Sharepoint

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