O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

  1. 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required