Figure 4: Export Access 2007 Table Data to WSS v3 Lists
Select a table in Microsoft Office Access's left-hand navigation pane and click the SharePoint List button in the External Data ribbon's Export group to generate a corresponding list in a WSS v3 or MOSS 2007 site. Access 2007's External Data ribbon also provides a Move to SharePoint command in the SharePoint Lists group that exports all table data to corresponding WSS v3 lists, adds Access table links to the lists, and optionally adds a shared copy of the database to the site's document library. After the move, executing the Take All Offline command removes the links and copies the list items locally. When you make changes offline, the Reconnect All command updates the lists and reestablishes the link.