Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Data Type for Account and Work_email fields in a List Column

  Asked By: Jennifer    Date: Jan 24    Category: Sharepoint    Views: 1361

I have problems updating a List using MS Access (or Excel) for columns
defined as Account (or Work_email) fields with "Allow selection of:"
as "People only" or "People and group".

These fields are given "Number" -long integer as data type.
Why? even though the values are displayed as text. ex: HQNT\XXX (for
Account) and xxx@... (for Work_email).

When I added a record using MS Access or MS Excel I got this error:
"Microsoft Office Access set 1 field(s) to Null due to a type
conversion failure..."



No Answers Found. Be the First, To Post Answer.