My Microsoft Access Database's Saved Imports don't work

As of right now, I am running the most current Microsoft Access program on my computer. It should be close to the 2019 one, but I am uncertain if it truly is.

However, I believe that the "saved imports" should work even in older versions.

Let me explain:

I am working on a project that imports an Excel spreadsheet (A very large, complicated one) and creates a report formatted in precise ways to display precise information. When importing the Excel details, I go through the process of selecting the workbook and choosing which columns to skip and which ones to import, etc. and then "save import steps". I don't have the import wizard analyze my table though because I have had issues with it in the past.

I have done this over 20 times due to the file changes. But even right after performing and saving the last import with the correct files, I first get the error: "Cannot delete a field that is part of an index or is needed by the system"

This is normal and fine to work around. However, I then get another error stating: "The specificiation failed to execute. Try re-creating the specification."

Which I have always assumed is the import process.

However, this is without changing anything on my PC after just creating the saved import.

This database is to be used on multiple different computers for a company, and it should automatically run the same import as long as the new file pathway/location is changed in the "Saved Imports" screen. But my database will not do this.

If anyone could give me insight on what I could be missing or doing wrong, I would greatly appreciate the help. I have run out of ideas.