Part V: Access and Windows SharePoint Services
1126
As the wizard progresses, you see a small dialog box indicating the progress of the con-
version process. The dialog box means that the Access table design is being copied to
SharePoint and a new SharePoint list is being created. When the conversion is complete,
the new SharePoint list is displayed in your default Web browser (see Figure 33.10).
FIGURE 33.10
The new SharePoint list created from an Access table- If you receive any errors or warnings, check the Show Details box in the wizard’s dialog
box, and read the information that is displayed. - Click the Close button in Access to dismiss the Export to SharePoint dialog box.
When the export process is complete, the data exists in two places: in the original Access table, and
as a SharePoint list. The two data stores are not connected, so if changes are made in either loca-
tion, the other application does not see the change.Certain fields do not export well to SharePoint. For instance, an OLE Object field is simply left
empty on the SharePoint side and contains no data. But most other field data types are properly
translated into compatible SharePoint columns and populated with data from the Access table.
Table 33.1 shows how Access data types are translated to compatible column types in SharePoint.
Notice that far fewer types of data are available in SharePoint lists than in Access tables. The data
types in Table 33.1 are applied any time an Access table is exported to SharePoint.