Forum Discussion
Solved
Append Data to Worksheet Data to Existing Table in DataModel
Hello Is there a way to take data from a worksheet range or table and append it to an existing table in an excel data model? Currently to only option I see available are: 1) write a VBA or R...
King7son1 It can be done by having a query append to itself, but you'll have to figure out a way to prevent it from appending new entries more than once, for example by deleting duplicates in the query. See attached example.
King7son1 It can be done by having a query append to itself, but you'll have to figure out a way to prevent it from appending new entries more than once, for example by deleting duplicates in the query. See attached example.
