Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to solve the problem of error reporting when navicat is imported into Excel. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Recently, after installing navicat, I am ready to import the working data into the excel file (xlsx format). Follow the import wizard step by step, resulting in an error that the file cannot be opened. At that time, I suspected that it was a problem with my cracked version, and then I tried to import it in xls and csv format, which went smoothly.

This means that it is not the software itself. Then go to the Internet to search for the wisdom of our predecessors, and now sort out the solution to the problem, as follows:

(1) some people say that opening the excel table to import is a success.

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

(3) due to lack of driver, you need to download AccessDatebaseEngine from Microsoft's official website. The number of digits should be the same as that of navicat,office.

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

The first and second are the most common solutions on the Internet, but unfortunately, neither of them solved my problem, ⊙ xlsx ⊙, until the third solution, which perfectly solved opening files with the suffix xlsx.

In addition, if Microsoft Power BI lacks this driver, there will be a problem that the xls file cannot be opened.

On how to solve the problem of navicat import Excel error report is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.