Question: how to import excel data into table in mysql?
Answer: Edit MySQL Data in Excel Within MySQL for Excel, Open a MySQL Connection, click the employee schema, Next, select the location table, click Edit MySQL Data, then choose Import to import the data into a new Microsoft Excel worksheet for editing.