I want to import the excel sheet data into the table using the Import CSV to Database smart service but I'm getting the outputs that Invalid column name: First Name .
Can you help/suggest on how to provide the column names??
Thanks inadvance.
Discussion posts and replies are publicly visible
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:
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