Assuming that the SQL server tables are linked into Access, the usual way is
INSERT INTO mySQLServerTable (Fld1, Fld2, Fld3, ...)
SELECT FldA, FldB, FldC, ...
From myAccessTable
WHERE ... Some logical Conditions ...
This assumes of course that you are authorized to modify the SQL Server...