I have SharePoint list inserted as linked table in Access 2007.
When I need to refresh list I need to delete all records in that table and append new records (not all of them are new - some are existing).
This works fine but it always shows NEW next to all items (I know why - for this list they ARE all new).
Is there a way to update just the fields needing update (and delete others)?
I have two tables (issues and customers) related to each other. Now this list on SharePoint is actually temporary list (table), which data is constantly changing and it has its own auto number which is quite different from ISSUES table.
Some fields are changing other are deleted and I would like to update fields of SP list and delete ones I do not need.
When I need to refresh list I need to delete all records in that table and append new records (not all of them are new - some are existing).
This works fine but it always shows NEW next to all items (I know why - for this list they ARE all new).
Is there a way to update just the fields needing update (and delete others)?
I have two tables (issues and customers) related to each other. Now this list on SharePoint is actually temporary list (table), which data is constantly changing and it has its own auto number which is quite different from ISSUES table.
Some fields are changing other are deleted and I would like to update fields of SP list and delete ones I do not need.
