After you have designed your database in Access 2000, initiate the Upsizing Wizard by selecting it from the Tools/Database Utilities menu in Access.
Select the Use Existing Database option from the wizard as we will be using a pre-defined ODBC datasource to connect to the SQL Server.
Switch to the Machine Data Source tab and select the ODBC datasource which you have pre-defined to connect to the SQL Server and click OK to continue.
Enter the username and password you set up on your SQL Server database and click OK to continue.
Now select the tables you wish to export to the SQL Server database and click Next to continue.
The last few steps in the wizard can be set to your own preference although it is recommended to leave them as the default settings. Access will transfer your database to the SQL Server and finally give a status report after the operation. Upsizing has been completed.
