Union Collection into sql table

[Måns]

Hi I need to Union a Collection in to a Sql table. I can remove rows using the app but I can´t add any. 
Collection is named: TempAccess (multiple rows)

Table is named: Access

The columns are named the same in both: UserID, AccessID and in Access they are set as Primary Key.

I´ve tired this: 
ClearCollect('[dbo].[Access]',TempAccess)

and a bunch of other stuff.

Any Ideas?

[WarrenBelz]

Hi @Måns ,

Try

Clear(colNewCollection);
Collect(
   colNewCollection,
   '[dbo].[Access]',
   TempAccess
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Måns · Accepted solution]

Thanks for the input @WarrenBelz 

I solved my issue this way

Collect(
'[dbo].[Access]',
TempAccess
);

Best regards
Måns