HOW could I import data of excel by the help of SQL to work effeciancly
SQL with excel
Are you trying to import data into a database with HeidiSQL?
If so, open the excel file and save it as a csv file. You will want to make the data in the excel file as close to the tables format as possible, same columns, etc. Then in HeidiSQL, under the tools menu button, you will see a button "Import CSV file...". There are many options in the dialog that pops up, I won't cover them here.
I would create a test database, and test importing that excel file until get the format and settings correct before importing into your actual database.
Please login to leave a reply, or register at first.