If for some reason or company policy you are not able to link SQL Server table to your Access database then the solutions are:
1- Ask SQL Server developer to export the data needed on your Access database then import into it.
2- Data entry.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.