Insert data table Column contains space to SQL server

[Sweta_Chaurasia]

I am getting an error while inserting data form excel to SQL server using Insert activity in Uipath as the Column name of excel contains space. Please help me to insert data without removing space from the Column name.

[ppr (Peter)]

@Sweta_Chaurasia

give a try on surounding column name with ’ like

[Sweta_Chaurasia]

Hi Peter. Thanks for your reply. But I am using Insert database activity in uipath. And I am try to insert data from excel sheet to SQL server. Is it possible to insert data to SQL server without removing space form the column name?

[ppr (Peter)]

@ppr

‘Business Name’

had you tried to surround the Column name with ’ ?

[Sweta_Chaurasia]

Hi Peter, First I have use read range activity and store the data in a data table after that I am using Insert activity to insert data in SQL server. Here where I can surround the column name like this ’ column Name’?

[ppr (Peter)]

in general it is advisable not to have space in column name

so what is the exact name from database datacolumn structure for a column with space in name?
you can try to change the datatable (this one from read range) by
yourdtVar.Columns(“ColNameOrIndex”).ColumnName = “NewName”

and bring it into a form that it is matching the name from database

[Sweta_Chaurasia]

Yes, I know that it is not advisable to have space in column name. But it is my requirement to automate the task. Previously the excel sheet was inserted using SQL server Import and it allows space in column name. So now I can’t change the column name format. Searching for an alternate option so that I can insert data without removing space.

[ppr (Peter)]

@Sweta_Chaurasia
as you can modify the datacolumn names from datatable (output from readrange) you have a chance to RnD it. This was mentioned above. Typically surroundings can be ’ or [

otherwise have a look here:

Error with DATABASE insert Activity

@Sugumar8785 you can do one thing …create store Proc for that and use Execute Non Query activity CREATE PROCEDURE [dbo].[Insert_Customers] @tblCustomers CustomerType READONLY AS BEGIN SET NOCOUNT ON; INSERT INTO Customers(CustomerId, Name, Country) SELECT Id, Name, Country FROM @tblCustomers END

[Sweta_Chaurasia]

Thanks for your efforts. I am working on the code.

[AVipani (AV)]

Hi Sweta

Has anyone found a solution to this.

Am having a Merge query to be passed in Execute non-query and the column names have spaces in them.

Also, Uipath does not support multi line query ?

Appreciate if someone can post a solution here.