Microsoft Access 2010 Bible

Part V: Access and Windows SharePoint Services

1128

FIGURE 33.11

The Move Data ribbon group contains some important wizards.

SharePoint export command

Move Data group

FIGURE 33.12

The Export Tables to SharePoint Wizard dialog box specifies the destination SharePoint site.

The Next button initiates the export process, which may take more than a few minutes, depending

on the number of tables in the Access database, the volume of data in each record, and the effi-

ciency of the SharePoint server hardware and software. You may also be asked for your SharePoint

user name and password because SharePoint must verify that you have the proper permissions to

create objects in the destination SharePoint site.

The newly created SharePoint lists are given the same name. The export might fail if an Access

table name does not conform to SharePoint naming rules. For example, Access table names may

contain spaces and limited punctuation characters, while SharePoint tables are plain text with no

spaces. If the export fails, it’s likely to be caused by a list-naming violation.