Forum Discussion
Question on exporting MS Access tables to Sharepoint Online List
I have a MS Access file with 14 tables. Some of these tables I am able to export them without any issue. However I noticed that some tables have records where each have "sub records" in collapsable format" (see attachment for sample).
When I export to Sharepoint online list, it only exports the main records and not their respective sub records (if any). Is there a way to export all records including the collpasables ones?
Thank you in advanced
3 Replies
Those are records in another table that is related to the main table. you can create something similar in SharePoint by using Lookup tables. To do this, you will need to create the reference/lookup tables/lists before you create the main list.
While SP has the ability to link together several lists, I would not recommend trying to do this with more than 3 levels deep. The user experience typically becomes complicated, unless you do some custom coding.
- I think there is not such a way and I see quite logical since the concept of subrecords does not exist in SPO lists
jcgonzalezmartin wrote:
I think there is not such a way and I see quite logical since the concept of subrecords does not exist in SPO listsSo sad to hear that honestly.
Thank you for the answer!
