如何将Excel文件导入MySQL Workbench? [英] How to import excel file into MySQL Workbench?

问题描述

我已经在Google上进行了搜索，但是所有示例均基于旧版Excel.我当前的Excel在数据"选项卡上没有MySQL选项.我尝试通过其他源" SQL Server导入，但未通过服务器名称"连接.我不明白为什么或输入错误的服务器名称.应该不是本地主机吗?

I've googled this but all the examples are on an old excel. My current excel does not have the option of MySQL on the Data tab. i tried importing through Other Source, SQL Server but it doesn't connect through Server name. I don't understand why or if i'm putting in the wrong Server name. Should it be something other than localhost?

推荐答案

您不能在MySQL Workbench中导入Excel文件.这是永远不可能的，因为它需要解析excel文件.而是将Excel中的Excel文件导出为CSV，然后将其导入MySQL Workbench.

You cannot import an excel file in MySQL Workbench. That was never possible as it would require to parse the excel file. Instead export your excel file in Excel to CSV and import that in MySQL Workbench.

通过MySQL Workbench将CSV导入MySQL很容易.从架构树中打开表数据导入向导":

Importing CSV into MySQL via MySQL Workbench is easy. Open the Table Data Import Wizard from the schema tree:

它允许您导入CSV和JSON数据.在下一页上选择您的文件，也设置导入选项(例如，分隔符和引用char)，然后运行它.

It allows you to import CSV and JSON data. Select your file on the next page, set import options too (e.g. separator and quote char) and then let it run.

这篇关于如何将Excel文件导入MySQL Workbench?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！