Beginning Access™ 2007 VBA

8.4. Using Data from SharePoint Lists

Before you start using Access with SharePoint, you need to have a SharePoint instance available to you. If you do not have an instance of SharePoint available, you can download a trial version from Microsoft. At the time of writing, you could download a trial version from http://office.microsoft.com/en-us/sharepointserver/FX100492001033.aspx. As one further caveat, SharePoint can only be installed on Microsoft Windows Server 2003 Service Pack 1 or later. If you prefer not to host the SharePoint software yourself, there are many Internet hosting companies that offer SharePoint hosting on their servers for a small monthly fee. One example of such a company is 1&1 Internet (www.1and1.com). Some of these Internet hosting companies offer a free trial.

Now that you know what a SharePoint List is and what the different types are, it is time to start working with them.

8.4.1. Linking and Importing SharePoint Lists

Importing a SharePoint list is very similar to importing data from other external sources, as described in Chapter 7. There are two ways to import a SharePoint list: using the Access menus and through VBA. This section will demonstrate both.

Try It Out: Importing Lists Using the Wizard Create a new database by selecting the Office Button New. From the list of available templates, select "Blank Database," provide the file name and path, ...