Access Table Linked to Sharepoint List (1 Viewer)

I have a split database that is stored on a network drive. Most of the tables are updated via the front end with use of forms. I would like to have one table that is updated solely through a SharePoint List. All of my queries and reports are currently built with an existing table. I have looked into linking to SP, but it creates a new copy of the table. Can I then link the 2 tables? So that my queries/reports all work?

Project Table = exists today

When trying to link, creates a new table Project Table 1.

Jessica,

I think that instead of using the import & link option you should use move data under the Database tools then it will give you the option to select which tables you'd like to move.

Samantha