Convert sharepoint linked table to local table

[AliyuKatsina]

Hi,

I wish to convert an imported sharepoint list to local table via vba.

the import is successful, however converting the list to a local table is my headache.


This is the code I used:

DoCmd.TransferDatabase acImport, "Microsoft Access", FPath, acTable, "SchoolList", "AccessTbl", 0

DoCmd.SelectObject acTable, "AccessTbl", True

RunCommand acCmdConvertLinkedTableToLocal

I got Error message no 2046 that the command ConvertLinkedTableToLocal is not available now! Please what is available now to accomplish the same task? :banghead::banghead::banghead:

 

[isladogs]

I've never worked with Sharepoint.

However, the first line of your code imports tables as local anyway
So the other two lines are I believe redundant and are I think the cause of your error
This should be all you need:

DoCmd.TransferDatabase acImport, "Microsoft Access", FPath, acTable, "SchoolList", "AccessTbl", 0

To link to an external table, use acLink rather than acImport
Then the other two lines will convert it to local without error.

DoCmd.TransferDatabase [B][COLOR="DarkRed"]acLink[/COLOR][/B], "Microsoft Access", FPath, acTable, "SchoolList", "AccessTbl", 0

DoCmd.SelectObject acTable, "AccessTbl", True

[B][COLOR="DarkRed"]DoCmd.[/COLOR][/B]RunCommand acCmdConvertLinkedTableToLocal

The simplest way of converting linked to local involves no VBA.
Right click on the table in the nav pane and click 'Convert to Local Table'.
Just make sure the table isn't in use when you do so