Linking tables to SharePoint - Access Developers


	Back to Access Developers Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Linking tables to SharePoint

Dexter Johnson

2 years ago

I only have 8 tables total that I want to link to SharePoint. This is the only option I have from my company. I have 1 table name ' ProcessImprovementT' that I'm trying to export to a SharePoint list and I keep getting a error that states

'There was an error modifying list schemas. Failed to create field 'SDate' on table ProcessImprovementT'

How do I fix this?

	Alex Hedley @Reply 2 years ago
What Field Type is `SDate`?

	Dexter Johnson OP @Reply 2 years ago
It's a extended date field

	Dexter Johnson OP @Reply 2 years ago
Date/Time extended

	Alex Hedley @Reply 2 years ago
MS Article: Using the Date/Time Extended data type

	Alex Hedley @Reply 2 years ago
MS Article: List and library column types and options

	Alex Hedley @Reply 2 years ago
Is that field type supported in SharePoint? If you create a new list in SP with a DateTime column and pull it into Access what type does it show?

	Dexter Johnson OP @Reply 2 years ago
OMG, I just fixed it. All I did was change it from Date/Time Extended to just Date/Time

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.

Next Unseen

New Feature: Comment Live View