Hi am new to this forum but found the question intersting....so trying.... 🙂

From your latest response, it seemd like you want to create some kind of a stg/tmp table where you get the results as a parking spot and do rpocessing on that. The next day, again clean the table and get fresh data.

For that, you need to create an sp where first you truncate / delete your table and then get the fresh data in.

So everyday, the workflow will be.....truncate data and then data in again.

But from your first question it seemed you had a linked tables(in the access world) and that your new sql db also has a linked server setup. In that case the syntax to access tables across a linked server is as follows :

[linkedserver].[dbname].[ownernm].[tablenm]

Hope this helps

Regards