none
Cannot upload Access Database in sharepoint RRS feed

  • Question

  • hi.

    I'm Using  Access 365 and  SharePoint 365 account.

    When I try to export tables from my database to sharepoint.  it creates duplicate tables. which effects lookup relationship. 

    for Example:

    Table A looks value from Table B

    Table C looks Value from Table B

    Then if I upload table A. The Table B itself goes there along with table A

    and then when I Upload Table C. Table B again goes there as Table B_1

    So. I do changes in table B. Table B_1 will not update the new records. 

    Can Any One please help me in this issue. Hope you understand the issue

    Thanks.

    Tuesday, October 24, 2017 5:07 PM

All replies

  • Hi,

    Rather than do each table manually, one by one, have you considered using the Migration Assistant to export all the tables for you?

    Just a thought...


    PS. I don't have Access 365, so I am not sure where it is located. Typically, it would be in the External Data Ribbon Tab. Look for something like "Migrate to SharePoint" or something similar.
    • Edited by .theDBguy Tuesday, October 24, 2017 5:18 PM
    Tuesday, October 24, 2017 5:16 PM
  • Hello,

    The issue does exist if you export tables one by one.  

    I would suggest you go to Database Tools -> Move Data -> SharePoint to export all tables to SharePoint and it would create SharePoint links and link each list back to the database.

    Regards,

    Celeste 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, October 25, 2017 9:07 AM
    Moderator