First Approach: I have Microsoft access database which has multiple relationships within a table. I have tried to import data into SharePoint list but an issue is that every time it is creating a new list for relation table. hence, I have multiple lists with same data and I can not maintain lookup.
Second Approach: I have created a console application to insert data using CSOM into SharePoint online, but it is taking so much time.
As we are inserting records using CSOM, this approach insertion is done by one by one record and each record is taking at-least one second to update in a list. hence I am looking for an option like a bulk insertion.
Do we have any other approach to migrating data from access database to SharePoint online?