Hi everyone,
I want to convert the back end data tables of my split database (Access 2013) into SharePoint 2013 lists.
The first step I did was to make those tables local to the database then build the database sub-site on SharePoint.
I then proceeded to export those tables to SharePoint by using the Database Tools >SharePoint button and pointed the target lists location to the newly created sub-site.
The process runs OK but when I take a look under the tables in the database, I see a local table named "Move to SharePoint Site Issues" that contains a single record with the following fields:
Issue: Some data will not be moved.
Reason: "SharePoint only supports 8192 characters in memo fields.
Object Type: tblMyData
Field Name: Notes
The Notes field is "Long Text" Data Type and when I exported the table to a Spreadsheet the largest has a character count of only 4000.
When I examine the data further I noticed that there are a few carriage returns where the user has hit "Enter" key to separate their notes by a date.
Does anyone know what might be causing this error?
Thanks in advance.
I want to convert the back end data tables of my split database (Access 2013) into SharePoint 2013 lists.
The first step I did was to make those tables local to the database then build the database sub-site on SharePoint.
I then proceeded to export those tables to SharePoint by using the Database Tools >SharePoint button and pointed the target lists location to the newly created sub-site.
The process runs OK but when I take a look under the tables in the database, I see a local table named "Move to SharePoint Site Issues" that contains a single record with the following fields:
Issue: Some data will not be moved.
Reason: "SharePoint only supports 8192 characters in memo fields.
Object Type: tblMyData
Field Name: Notes
The Notes field is "Long Text" Data Type and when I exported the table to a Spreadsheet the largest has a character count of only 4000.
When I examine the data further I noticed that there are a few carriage returns where the user has hit "Enter" key to separate their notes by a date.
Does anyone know what might be causing this error?
Thanks in advance.