Export excel file to sharepoint folder (1 Viewer)

[tucker61]

I currently exportbreports yo excell and then distribute to our team, I want to run a macro to export the data into a SharePoint folder.

How easy is this to do ?

Regards

Sent from my SM-T715 using Tapatalk

 

[ashleedawg]

...to export data from Access to Sharepoint?

Here is an example using docmd.TransferDatabase from MSDN :

DoCmd.TransferDatabase transfertype:=acExport,
          databasetype:="WSS", _
          databasename:="[I]http://example/WSSSite[/I]", _
          objecttype:=acTable, Source:="Customers", _
          Destination:="Customer List", structureonly:=False