Access to SharePoint Table Upsizing Errors

What Should You Do Before You Upsize To SharePoint

Step one, convert your database to ACCDB format using Access 2007. This will allow you to run the Move to SharePoint Site Wizard

If you get an error "Microsoft Access was unable to transfer data to Microsoft SharePoint services site. The Copying Data to SharePoint List for tblXXXXX step failed.  This may mean that you have a problem with the site name or it could mean that you have a problem with the table structure.  Anyway

1. Copy and paste the name of the Sharepoint site from your browser 
2. Try a really simple table to make sure that you can export a table to SharePoint
3. Have a look for a table called
   "Move to SharePoint Site Issues". Open this then look at the issues mentioned in the table.

So lets have a look at this issues that can occur and because I feel so strongly about relationships and design of databases, lets first look at what is not transferred in relationships.

Unique Indexes, Referential Integrity and Table Relationships Are Not Supported When Upsizing To SharePoint

Type of data or issue	Issue	Result
Referential integrity	SharePoint sites do not support referential integrity.	Referential integrity is not enforced in the new list.
Unique index fields	SharePoint sites use one unique index field for its ID column in a list.	Other unique index fields or sets of fields are not moved.
Relationships with cascading deletes or updates	SharePoint sites do not support cascading deletes to related records.	Deletes are not cascaded to related records, and updates are not cascaded to related fields.
Relationships that enforce referential integrity	SharePoint sites do not support referential integrity.	Referential integrity is not enforced in the relationships between data in the lists.
Relationships in which lookups cannot be created	Some relationships are not supported in SharePoint sites, such as when the primary key is not related to the ID column or is not an integer.	The relationship is not moved.

 

Things That Are Not Supported When Upsizing To SharePoint

Type of data or issue	Issue	Result
Date	SharePoint sites do not support dates prior to 1900.	Data with dates prior to 1900 is not moved.
New line characters in text fields	SharePoint sites do not support new line characters in a Single Line of Text field.	Field is converted to a Multiple Lines of Text field or Memo field.
Decimal data type	SharePoint sites do not support the Decimal data type.	The Number field or Double Integer field is used instead.
Default values that are not supported in a SharePoint list	SharePoint sites accept default values that are static, such as text or a number, as well as standard dates. Default values from Access that are dynamic are not migrated.	Certain default value properties are not moved.
Data validation on a field or table	No data validation rules are moved to SharePoint sites.	Any data validation on a field or table is not moved or enforced.
Unique index fields	SharePoint sites use one unique index field for its ID column in a list.	Other unique index fields or sets of fields are not moved.
Fields that enumerate automatically (other than the ID field)	SharePoint sites support only automatic numbering for the field used for the ID column in a list.	Automatic numbering is not applied to columns other than the ID column.

Now some of this material was gathered up from this page at Microsoft entitled Move the tables in an Access database to a SharePoint site and link to them

A Table That Will Not Move To SharePoint

When trying to transfer a Contacts table to SharePoint, I got the error "Microsoft Access was unable to transfer data to Microsoft SharePoint services site".  Now I could find no real reason for this.  But I could transfer the table when it was empty.  So I resorted to transferring the empty table then linking then working on transferring the information.

 

 

Other Articles That You Might Want to Read at Our Site

Secure Microsoft Access Passwords and Encryption in Access 2007

Read the page on using SharePoint designer for backups and moving sharepoint sites around

Read our Expression Web page

Backing Up Your Access Data With XML

Preparing To Upgrade Access Tables to SQL Server 2005/2008

Other Related Articles Somewhere Else

Should I use SharePoint Designer or Expression Web

Download Different SharePoint Templates from Microsoft

Including The Timecard Management application template helps teams track hours spent working on various projects. Team members ‘punch in’ and ‘punch out’ of work on project tasks. Managers can view the total hours spent by project and by person.