Importing SharePoint list

[darrbeck]

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

[June7]

Crosspost http://forums.aspfree.com/microsoft-...st-535743.html