i am getting error while entering the excel sheet to mysql server. why this error is coming.
1)Check your connection first to connect mysql database.
2) your insert query should be single line with proper syntax.
Below is the workflow which successfully insert the values to DB from Excel.
ArjunMain.xaml (12.4 KB)
Below is the Excel values which i am inserting to DB.
Output from DB :-
Just make the changes as per your requirement.
For Eg :- Excel File Name, Variables name, Make connection to your DB Table and update variables and table name in INSERT Query as per your requirement.
Hope this may help to solve your issue
Mark as solution if this helps you and like it
Er Pratik Wavhal