I have the need to manage in Access more than 30,000 rows of data (across 50 columns), currently in Excel.
Can someone recommend a best practice for this action?
Is 30,000 lines too big to import from Excel to Access?
Should I just go straight at the data in Excel OnDrive from Access as a 'linked' table?
Would using flow to create an SP List of the Excel data, and using Access to get at it in SP a viable option?
