How do I insert data from "table in SQL Server" to "table in Access"

[jmcilhinney]

You said that you need to insert data. Why are you trying to update data all of a sudden? Please provide a FULL and CLEAR description of EXACTLY what you're trying to achieve. If we don't know what problem we're trying to solve then we probably won't be able to solve it.