excel2016 POWER QUERY 连接MYSQL数据库报错
答案:1 悬赏:20 手机版
解决时间 2021-01-24 21:56
- 提问者网友：我的未来我做主
- 2021-01-24 02:38
excel2016 POWER QUERY 连接MYSQL数据库报错
最佳答案
- 五星知识达人网友：旧脸谱
- 2021-01-24 03:01
按照以下步骤执行，就不会提示了：
In the POWER QUERY ribbon tab, click From Database > From MySQL Database.
In the MySQL Database dialog box, in Server Name specify the MySQL Database Server to connect to.
If you want to import data using native database query, specify your query in the SQL Statement box. For more information, see Import Data from Database using Native Database Query.
Click OK.
If the MySQL server requires database user credentials:
In the POWER QUERY ribbon tab, click From Database > From MySQL Database.
In the MySQL Database dialog box, in Server Name specify the MySQL Database Server to connect to.
If you want to import data using native database query, specify your query in the SQL Statement box. For more information, see Import Data from Database using Native Database Query.
Click OK.
If the MySQL server requires database user credentials:
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯