Hi all,
I have a back end of split database (the tables) on Microsoft Sharepoint.
I have used:
< DoCmd.TransferDatabase acImport, "Microsoft Access", FullpathToHoldFile, acTable, strOldTable, strNewTable, False > to import tables from a local database
(< FullPathToHoldFile > is the path to the other database on my computer) I would like to use the same method in vba to import the data from my linked Sharepoint site.
1) Can I replace < FullPathToHoldFile > with the path to Sharepoint to achieve the same result (Transfer Data to a local file without cutting the link?)
2) If so, then how can I find the path to the Sharepoint site from my computer.
I have tried putting in the URL <http://seedrs.sharepoint.com/TeamSite/Test> but this doesn't seem to do anything.
Is this possible at all?
I am basically trying to back up Sharepoint data on a regular basis without converting to local tables then having to relink.
Any ideas appreciated....
I have a back end of split database (the tables) on Microsoft Sharepoint.
I have used:
< DoCmd.TransferDatabase acImport, "Microsoft Access", FullpathToHoldFile, acTable, strOldTable, strNewTable, False > to import tables from a local database
(< FullPathToHoldFile > is the path to the other database on my computer) I would like to use the same method in vba to import the data from my linked Sharepoint site.
1) Can I replace < FullPathToHoldFile > with the path to Sharepoint to achieve the same result (Transfer Data to a local file without cutting the link?)
2) If so, then how can I find the path to the Sharepoint site from my computer.
I have tried putting in the URL <http://seedrs.sharepoint.com/TeamSite/Test> but this doesn't seem to do anything.
Is this possible at all?
I am basically trying to back up Sharepoint data on a regular basis without converting to local tables then having to relink.
Any ideas appreciated....
