navicat cannot import 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. This means:

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:

●Some people say that opening the excel table will lead to successful import

●navicat and excel are both 64-bit or 32-bit

●The driver is missing. You need to go to the Microsoft official website to download AccessDatebaseEngine. The number of bits 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 are the most common solutions on the Internet, but they are very Unfortunately, none of them solved my problem⊙﹏⊙ until I adopted the third solution, which 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 of being unable to open the xls file~ So you can figure it out by yourself??

The above is the detailed content of navicat cannot import excel. For more information, please follow other related articles on the PHP Chinese website!