Skip to main content
S
sravanis918
July 26, 2021
Question

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

  • July 26, 2021
  • 11 replies
  • 0 views

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.

    11 replies

    selvakumark
    selvakumark
    Participating Frequently
    July 26, 2021

    Hi [mention:92e77b77b9d347dc8e7cd5a259a43751:e9ed411860ed4f2ba0265705b8793d05],

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

      S
      sravanis918Author
      July 26, 2021

      Hi Selvakumar,'

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

      selvakumark
      selvakumark
      Participating Frequently
      July 26, 2021

      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

      Terms & ConditionsAccessibility statement