Results 1 to 2 of 2
  1. #1
    darrbeck is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    1

    Importing SharePoint list

    I have semi-successfully imported my SharePoint list into Access. I have also saved my import to easily run in the future (did this thinking it was a step towards setting up an automated archiving process but now think macro is different than saving the import)

    Now my questions begin:
    1) Everytime I do an import this creates a new table in access - How can I append to the existing table?

    2) In order to make #1 work properly I need to also delete the records out of SP when the import occurs so there are not duplicate itmes.

    3) I ONLY need to import/delete the list itms that are marked as "complete" instead of "open" which is one of the list columns.


    Any help would be greatly appreciated.

    Thank you in advance,
    Darren

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,030
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing and exporting data from a Sharepoint site
    By siddharthnk in forum SharePoint
    Replies: 0
    Last Post: 06-15-2012, 09:28 PM
  2. Link Access Query to Sharepoint List
    By mlm in forum SharePoint
    Replies: 0
    Last Post: 04-24-2012, 03:06 PM
  3. Contact list in Sharepoint 2010
    By atari in forum SharePoint
    Replies: 1
    Last Post: 10-28-2011, 04:12 PM
  4. import/export attachments to SharePoint list
    By Cojack in forum Import/Export Data
    Replies: 0
    Last Post: 07-15-2011, 01:39 AM
  5. Replies: 1
    Last Post: 09-26-2009, 02:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums