You can connect a MS-Access database to SQL Server as a linked server, and query Access tables in SQL Server’s Query Analyzer. This can help in porting data from Access to SQL Server.
Using a defined JOB in SQL Server, you can almost replicate an Access table into SQL Server at a scheduled time.