Anith Gopal

Hi all,           Before writing something that would take some time to do in terms of loading data, I was able to successfully conduct a bulk load of data into SharePoint with MSAccess.  Here is my mock up test that I did.  I created a SharePoint list in a sample site with the following schema: Sample List Title                                 Single Line of Text Sample Column                  Single Line of Text Sample Lookup Column       Lookup to a Contacts List I chose these columns because they represent some non-standard column types of mapping in order to do bulk loads with.  I then created a new Access 2007 database and linked to the [Sample List] in SharePoint.  I then created a mirror data load table in the access database with the following schema Sample List Local Source ID                          AutoNumber Title                       Text SampleColumn         Text SampleLookupValue  Number Note that the source data for inserting into a SharePoint list lookup column via Access is a number (the actual ID of the specified target value of the Lookup list).

Excerpt from:
HOWTO: Bulk Load Data Into SharePoint Lists via Access 2007