Access Link Table from excel file located in Sharepoint folder for shared database

I have a Power Automate workflow to send an email weekly with an excel file attached. The excel file is saved in a document library on SharePoint (not a SharePoint list). I need to link this excel file as a linked table in my database that my team use (multiple users). The database is shared on a network drive. I will have an update query that will update records in the excel file (will build the query when I can link the table).

I can sync the SharePoint folder to my local PC and link from there however, this will error when my team update the records as a local link is just that, local to me.

How can I link to the excel file on SharePoint so that all database users can update?