check for duplicates
I'm relatively new to the SForce Connector.
What I would like to do is use the connector to add new contacts. I have spreadsheets with contact data from vendor shows, and I would like to add them into SF. This is pretty easy to do with the SForce Connector, but is there a way to check for duplicates first?
To clarify, I would like the SF Connector to first query to find duplicates, then add any that are not already in SF.
I've had the Excel Connector installed and working fine for months, but today when I try to use the Query Wizard it returns an Excel dialog box with the error message:
I've tried closing Excel and replacing the xla file, but still get the error.