Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Hello,
I am using "Import Excel to Database" smart service and getting an error "???Unknown column '' in 'field list'???" while writing to the data base. When I check the logs its adding one null column by default, Can anyone please help me in understanding the cause for this error and how to fix it?
insert into `MyTableName` (`ID`, `EID`, `Name`, `Notes`,``) values (\'1\', \'2\', \'gh\',\'\')',1054
check if there are empty column after notes. If not copy the content data from the sheet and paste it into new sheet and try it out it might work.
Could you please provide detailed steps to configure "import Excel to Database"