How to read values from excel and create bulk insert query using sequelize with node js

The below code is the single insert codeinsertData: function (sqlQry, dataJson) { var deferred = new Q.defer(); sequelize.query(sqlQry, { raw: true, replacements: dataJson, type: sequelize.QueryTypes.CREATE }) .then(function (result) { deferred.resolve(result); }, function (err) { deferred.reject(err); }).catch(function (err) { var reslog = { "status": "Error", "message": err + "" } deferred.reject(reslog); }); return deferred.promise; }, i want to insert multiple data in mysql with sequelize.

Submitted May 17, 2018 at 08:17AM by ElumalaiKutty