Import excel to database

Hi,

I'm using 'Import excel to database' smart service in the process. When I run the process, it executes successfully, but does not write anything to database table. Does anyone have suggestions?

Parents
  • Hi Ashok, I faced this issue too. The problem is with the excel template. The solution that worked for me was, I exported the table as CSV for Excel from database.(The table where you want to dump data). And then convert this CSV to excel, then use this template to upload data, things should work fine for sure. Also remember to separate the comma separated values to row 1 of excel - column headers. Try and let me know if you have questions !

Reply
  • Hi Ashok, I faced this issue too. The problem is with the excel template. The solution that worked for me was, I exported the table as CSV for Excel from database.(The table where you want to dump data). And then convert this CSV to excel, then use this template to upload data, things should work fine for sure. Also remember to separate the comma separated values to row 1 of excel - column headers. Try and let me know if you have questions !

Children

 Discussion posts and replies are publicly visible