Import the excel data into the table using Import CSV to Database smart service

Hi sravanis918,

The table column names should be provided as-is for this smart service to function properly.

Hi Selvakumar,'

I have provided the table column names even but still I'm getting the same error as Invalid column name : First Name

Just to make sure my understanding, could you please answer the below:

1. You have given the exact column names as of the table in the Excel file header row.
2. In the smart service configuration, the parameter 'File Has Header' is set to true.
3. In the smart service configuration, the parameter 'Column Names' is not configured.

If anything is different, then do share a screenshot of the smart service configurations

Just to make sure my understanding, could you please answer the below:

1. You have given the exact column names as of the table in the Excel file header row.
2. In the smart service configuration, the parameter 'File Has Header' is set to true.
3. In the smart service configuration, the parameter 'Column Names' is not configured.

If anything is different, then do share a screenshot of the smart service configurations

1) No

2)yes

3)No

If the file has a header is set to true, then the smart service will take the first row names as the column names. Hence it finds a mismatch between the database table and the given file. Please try changing the column names in excel, then it will work.

ok thanks, I will try that and one more thing is So there is no need of configuring the column names input right??

If it is given in the file, then not needed in the smart service.

these are my column names in excel file

yes the column names are there in the excel file 

I hope that the table column names will be like FirstName (or) First_Name without space. We need to give that name here.

ok thank you for your help