One way to convert Access database to Sql Server database is through Access’ built-in Upsizing Wizard, accessible through Tools -> Database Utilities -> Upsizing Wizard. It works both with Sql Server 2000 and Sql Server 2005. When upsizing, you are provided with basically 3 choices: converting Access database to a ADP project; converting all tables…