UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Import Into Sharepoint, SharePoint 2013    
 
   
bakersburg9
post Oct 28 2017, 04:19 PM
Post#1



Posts: 4,952
Joined: 2-November 04
From: Downey, CA


I'm usually optimistic about these things, but not so sure - you can export lists from Sharepoint to Excel and Access - can you Export from Excel/Access BACKinto Sharepoint ?
Go to the top of the page
 
theDBguy
post Oct 28 2017, 04:54 PM
Post#2


Access Wiki and Forums Moderator
Posts: 71,196
Joined: 19-June 07
From: SunnySandyEggo


Hi Steve,

Yes you can, but maybe it's not as straightforward as exporting from SharePoint. For example, in Access, you "publish" tables into SharePoint, and for Excel files, you can copy and paste into a SP List.

Just my 2 cents...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
bakersburg9
post Oct 28 2017, 08:22 PM
Post#3



Posts: 4,952
Joined: 2-November 04
From: Downey, CA


I wanted to update/edit,but thanks anyway - didn't think you could - maybe I could figure out a workaround - like with sorting, and seeing the imported record next to the "original" Thanks!
Steve
Go to the top of the page
 
theDBguy
post Oct 28 2017, 10:58 PM
Post#4


Access Wiki and Forums Moderator
Posts: 71,196
Joined: 19-June 07
From: SunnySandyEggo


For update and edit, you can link the SP List in Access, so you can easily JOIN your tables.

Good luck!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
bakersburg9
post Oct 30 2017, 03:50 PM
Post#5



Posts: 4,952
Joined: 2-November 04
From: Downey, CA


DbGuy,
THIS is interesting - I've been exporting lists from Sharepoint to Excel, but I clicked on the Access button, and this dialogue came up - it says
QUOTE
This list will continue to be stored on the Sharepoint site. Changes to the data in Access will automatically be updated in the sharepoint list.

Attached File(s)
Attached File  UpdateSharepointFromAccess.png ( 20.19K )Number of downloads: 2
 
Go to the top of the page
 
theDBguy
post Oct 30 2017, 03:52 PM
Post#6


Access Wiki and Forums Moderator
Posts: 71,196
Joined: 19-June 07
From: SunnySandyEggo


I think it's because you're basically creating a "linked" table in Access. If you select the other radio button, then the warning should go away, and you'll end up with a local copy of the data instead.

Just my 2 cents...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    10th December 2017 - 09:27 PM