I already went ahead and installed Connections Pro and some of the add-ons, and it’s working great. But I did see on the forums for a similar plugin that if you can keep the ID the same, it would overwrite the data. Would that also work for Connections Pro? If so, it might be possible for us to add that ID # in our Access DB.
The ID, that would be the entry ID assigned by the WordPress db when the entry is added. This can be found on the Connections : Manage admin page under the View Details section of the entry.
If you can add this data to your Access db then using the CSV Import extension, you can map the ID to the Entry ID and the CSV Import will instead update the entry with the new info, well, sort of. The data for addresses, phones, links… the fields that are repeatable when adding an entry. These are actually simply deleted and replaced with the data in the CSV file.
Hope that answers your question!