I think I would:

1) upsize your existing Access table(s) to SQL Server table(s)
2) replace the old Access table(s) with linked table(s) (pointing to SQL server table(s)).

The net effect would be your programs/users would still be using Access and the table would reside on SQL server.

Once you get to SQL Server, you'll get the opportunity to experience the joys of replication...