Access.2007.VBA.Bibl..

Converting Access Tables to SQL Server Tables ......................................................

To start the Upsizing Wizard, from the Ribbon’s Database Tools tab, click the SQL Server command

from the Move Data group, as shown in Figure 18.26.

FIGURE 18.26

Starting the SQL Server Upsizing Wizard.

The first screen of the Wizard (Figure 18.27; just like the one in Access 2003) offers a choice to use

the existing database or create a new one. Generally, it is a good idea to create a new database.

The Help button on the wizard screen shown in Figure 18.27 doesn’t open context-spe-

cific Help, as you might expect. Instead of getting a topic with information that would

help with the decision to use the existing database or create a new one, you get the main Access Help

screen, with a Table of Contents and a Search box. This is not an improvement over previous versions

of Access, where context-specific Help was generally available in wizards. In Access 2003, for exam-

ple, if you run the Upsizing Wizard and click the Help button on the first screen, you will get a “Use

the Upsizing Wizard” Help topic, with pertinent information for each screen of the wizard.

FIGURE 18.27

The first screen of the Upsizing Wizard.

CAUTION CAUTION

Working with SQL Server Data 18