无法从Excel XLSX文件导入

I have a MySQL database on a remote server. I have saved the contents of the database table as a CSV file. I have then imported that file as a worksheet into MS Excel and all is good. However, when I try to import the data from the MS Excel file as a table into an MS Access database (.accdb) using the "Import" function I get the following error:

我在远程服务器上有一个MySQL数据库。我将数据库表的内容保存为CSV文件。然后我将该文件作为工作表导入MS Excel，一切正常。但是，当我尝试将MS Excel文件中的数据作为表输入到MS Access数据库(.accdb)时，使用“import”函数，我得到以下错误:

The wizard is unable to access information in the file world.xlsx. Please check that the file exists and is in the correct format.

向导无法访问文件world.xlsx中的信息。请检查文件是否存在，并且格式正确。

The file definitely exists and is in .xlsx format.

该文件肯定存在，并且是.xlsx格式。

If I try to import the data from the .csv file into MS Access I get a different error message:

如果我试图将.csv文件中的数据导入到MS Access中，我会得到一个不同的错误消息:

Could not find installable ISAM

无法找到可安装的ISAM

It would seem that I am doing something wrong but searching in Google and this site I cannot see what my error is. Both files are in a folder that is listed as a "trusted location" to prevent errors due to lack of permissions.

看起来我做错了什么，但是在谷歌和这个网站上搜索，我看不到我的错误是什么。这两个文件都位于一个被列为“受信任位置”的文件夹中，以防止由于缺乏权限而出现错误。

I would be grateful if anyone can point me in the right direction as this has me well and truly stumped.

如果有人能给我指明正确的方向，我将不胜感激，因为这让我深受困扰。

Many thanks

非常感谢

Tog Porter

衣服波特

1 个解决方案

#1

I tried this on a different PC and it worked OK, so it must have been something corrupt with my MS Office installation.

我在另一台电脑上试用过这个，效果还不错，所以我的MS Office安装肯定有问题。

I completely uninstalled MS Office from my main PC and re-installed it, which fixed the problem.

我把MS Office从主电脑上完全卸载，重新安装，解决了问题。

Note: Using the repair function in Control Panel did NOT fix it, it had to be completely uninstalled.

注意:在控制面板中使用修复功能并没有修复它，它必须完全卸载。

Many thanks for your help and suggestions.

非常感谢您的帮助和建议。

Tog

衣服

#1