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