Importing and Exporting Access Data with SharePoint

You can use the Import, Link Tables, and Export commands in Access to exchange data from lists or views in Windows SharePoint Services. When you import or export data with SharePoint, the Windows SharePoint Services Wizard steps you through the process to convert the data between the two programs. Before you start the process be sure to have access information to connect to the SharePoint server.

Import or Link Data from SharePoint

Open the database in which you want to import data.

Click the File menu, point to Get External Data, and then click Import or Link Tables.

Click the File Of Type list arrow, and then click Windows SharePoint Services.

Enter the address of your SharePoint server.

Click Next, and then follow the remaining wizard instructions.

Export Data to SharePoint

Open the database containing the object you want to export, and then select the database object.

Click the File menu, and then click Export.

Click the Save In list arrow, and then select the drive and folder where you want to save the file.

Click the Save As Type list arrow, and then click Windows SharePoint Services.

Enter the address of your SharePoint server.

Click Finish, and then follow the remaining instructions.