Excel Tools

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

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

Could you please provide detailed steps to configure "import Excel to Database"

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.