What should I do if navicat reports an error when importing Excel?

I have just installed navicat recently and am preparing to import working data, excel file (xlsx format), follow the import wizard step by step, but an error occurs that the file cannot be opened. At that time, I suspected that it was a problem with my cracked version, so I switched to xls and csv formats and tried to import them, which went smoothly.

Related recommendations: "Navicat for mysql graphic tutorial"

This means that it is not a problem with the software itself. Then I went to the Internet to search for the wisdom of predecessors, and now I have sorted out the solution to this problem, as follows:

(1) Some people say that opening the excel table will lead to successful import.

(2) Navicat and excel are both 64-bit or 32-bit.

(3) The driver is missing. You need to go to Microsoft’s official website to download AccessDatebaseEngine. The number of digits should be consistent with Navicat and Office.

This is the portal: https://www.microsoft.com/zh-cn/download/confirmation.aspx?id=13255

The first and second types are the most common on the Internet solutions, but unfortunately, none of them solved my problem⊙﹏⊙Until the third solution was adopted, it perfectly solved the problem of opening files with xlsx suffix.
In addition, if Microsoft's Power BI lacks this driver, there will be a problem that it cannot open the xls file.

The above is the detailed content of What should I do if navicat reports an error when importing Excel?. For more information, please follow other related articles on the PHP Chinese website!