Forum Discussion

Phishdawg's avatar
Phishdawg
Brass Contributor
Oct 12, 2022

Large Excel File Recommendations

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?

access
  • tsgiannis's avatar
    tsgiannis
    Iron Contributor
    Oct 14, 2022
    30,000 is nothing for Access
    Just do the import and forget Excel

Resources