Skip to main content
K
kirang100133
July 27, 2022
Question

Import Excel to Database not working

  • July 27, 2022
  • 6 replies
  • 0 views

Hi All,

I am trying to import excel to database, but getting this error. I am using PostgreSQL database, is this smart service work with PostgreSQL?

Thanks,

Kiran

    6 replies

    D
    deepakg681722
    July 27, 2022

    Could you please check your table structure. I think ID is integer in your table and you are passing string for the insertion. You have to use toInteger("abc") function to insert the data successful id id is of integer type in DB Table

    K
    kirang100133Author
    July 27, 2022

    Hi deepak,

    Thank you for replying, I am using postgreSQL DB I have tried your way also still the same error. Can yyou please tell me Is this smart service work with PostgreSQL?

    harshitb6843
    harshitb6843
    July 27, 2022

    If you look at the recent comments on the AppMarket, it seems like it doesn't support PostgreSQL

    Terms & ConditionsAccessibility statement