First, here is a “Web View” of a basic Notes database (Orders.nsf) http://www.msdomino.net/orders.nsf/customer%20orders?openview

Now we use the URL Command “ReadViewEntries” to retrieve an XML version of the View. (Note: this is a built-in function of a Domino Server with the HTTP task running.)

http://www.msdomino.net/orders.nsf/customer%20orders?readviewentries&count=-1

(Note: the “&count=-1” parameter requests all documents in the View. However, this is still limited to 1000 but a default setting. See http://my.advisor.com/blog/garydev.nsf/d6plinks/GDEF-7QVRB8#comments )

We start Access 2007 and create and empty database.

Next we select “XML File” from the “Import” section on the ribbon.

A dialog appears asking for the source of the XML. Here we enter the URL for our URL command “ReadViewEntries” shown above and click OK.

The wizard imports the data and shows the a tree view of the schema which does not contain the data we want. We will need to apply a Transform. Click “Transform…”

The first step to using this XML to move the data to SharePoint requires Access 2007.

The wizard will ask you for the location of an XSLT file. You can down load mine here:

http://www.msdomino.net/firstpage.nsf/b29a5df9173b3feb88256e78000a0589/8c85c3b4013dfd448625754b000175ad?OpenDocument

Put it on your file system and point the wizard to it.

This is what the XSLT looks like

Now we have our XML data in a format Access 2007 likes. Click OK.

Here, just click Close.

Now we have an Access 2007 relational database with our Notes Data in it. Here you have the opportunity to go into the Database Design and set the Field data types. (ie. Number, Date, Time, String). This way you can easily cast the data into the desired format.

Finally, we select “SharePoint List” from the “Export” section of the ribbon. You are asked for the address of a SharePoint Site to create the new list in. Enter it and click OK

Here is a list created with Notes data without making any changes to the Domino server. I have made some changes to the default SharePoint View for formatting.