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

    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,

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    How to attach file: 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