Migrating Your Access Database to Microsoft SQL Server 7.0
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/access2sql.asp
look for instructions on
1. Migrating Microsoft Access Queries into Stored Procedures and Views
2. Migrating Microsoft Access Queries into Transact-SQL Scripts