Excel connected to non GP database
I can get the database populated the first time, however I now can not get the database to be updated.. the imports just keep adding additional rows. how can this issue be resolved?
Lewis, does your SQL table have a primary key associated with it? That is what SmartConnect will use to determine which record to insert/update.
Lorren.. I think you saved me again! I will run a test and let you know if that does the trick
If you would like to submit an answer or comment, please sign in to the eOne portal.