Large Excel File Recommendations

Brass Contributor

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?

1 Reply
30,000 is nothing for Access
Just do the import and forget Excel