连接步骤

1.下载ODBC驱动

直接使用Excel点击从MySQL中获取数,会提示需要你安装一个或多个组件,其实就是需要你安装一个ODBC驱动;

这里需要十分注意,32/64位不是取决于你的操作系统,而是取决于你的Excel;下载网址
连接MySQL

未安装驱动

常见错误

1.像这个情况,就是你没有下载和Excel同样的版本,此时如果你下载的是64位ODBC驱动,那么将32位的下载了即可;
驱动安装版本错误

2.如果安装驱动的过程中提示这个情况,将Visual Studio 2019安装后再将驱动安装就可以了,下面是各个版本的必要组件库下载路径,直接复制下载就可以了
图片说明

Microsoft Visual C++ Redistributable 2019
x86: https://aka.ms/vs/16/release/VC_redist.x86.exe
x64: https://aka.ms/vs/16/release/VC_redist.x64.exe

Microsoft Visual C++ Redistributable 2017
x86: https://go.microsoft.com/fwlink/?LinkId=746571
x64: https://go.microsoft.com/fwlink/?LinkId=746572

Microsoft Visual C++ Redistributable 2015
x86+x64: https://www.microsoft.com/en-pk/download/details.aspx?id=48145
x86+x64 update3: https://www.microsoft.com/en-us/download/details.aspx?id=53587

Microsoft Visual C++ Redistributable 2013
x86+x64 in all Language: https://support.microsoft.com/en-us/help/4032938/update-for-visual-c-2013-redistributable-package

Microsoft Visual C++ Redistributable 2012
x86+x64 in all Language: https://my.visualstudio.com/Downloads?pid=1452

Microsoft Visual C++ Redistributable 2010
x86-sp1: https://www.microsoft.com/en-pk/download/details.aspx?id=8328
x86-sp1-MFC-sec-update: https://www.microsoft.com/en-us/download/details.aspx?id=26999

Microsoft Visual C++ Redistributable 2008
x86: https://www.microsoft.com/en-us/download/details.aspx?id=29
x64: https://www.microsoft.com/en-us/download/details.aspx?id=15336
x86+x64-MFC-update: https://www.microsoft.com/en-us/download/details.aspx?id=26368

Microsoft Visual C++ Redistributable 2005
x86: https://www.microsoft.com/en-pk/download/details.aspx?id=3387
x64: https://www.microsoft.com/en-US/Download/confirmation.aspx?id=21254