How to insert a datatable to database table having column name with a space

Help Activities
, , , , ,
1

Hi all,
I’ve a datatable which has a column as (eg New york) with a space in between. The same column is also defined similarly in db table(in MS sql sever). When I’m trying to insert the whole datatable into database table, then I’m getting an error as column New not found. I’m using insert activity in UiPath. I can’t change column definition in db. Pls advise how to do it?

1 Like
2

Hey @debosree

Please change the column name in datatable similar to db.

Hope this helps.

Any help please let know.

#nK

3

Hi @debosree

Can your share me your insert query?

Regards