I have an access database with a table that is linked to an excel sheet. I also have a duplicate table with the same data linked to a postgres database. My goal is to either link these two tables in such a way where when the excel linked table gets updated so does the postgres linked table or link a single table to both excel and postgre, is this even possible?
My ultimate goal is to use the excel sheet's data in a website. The excel sheet is the primary data source and all CRUD operations are done in excel, my website is simply a dashboard to display that data. I want my website to pull the data from the excel sheet when someone makes an edit and saves the file. As far as I know there's no way to do this without buying software. Since Access edits auto update a postgres database my thought process was to keep the existing links from excel to Access and then create another link from access to postgres and use postgres as the database my App would connect to.