MySQL Workbench and
MS SQL Server Management Studio off & on over the years. The one thing I enjoy with
SSMS is the ability to copy information from an Excel document and paste it into the results pane of
SSMS. Is there a similar means of importing information into tables for
MySQL Workbench? This method is quick and easy. Right now the way I do it for MySQL is I export from excel to CSV file, then import to MySQL from CSV file. Thanks!
There’s no way to insert an entire Excel table into a result set in MySQL Workbench using only the clipboard. For this task your approach via a CSV file is the best one. There’s an option to copy/paste entire rows, though, which might be of help for small changes.
Answered By – Mike Lischke