Home > Database > navicat > body text

navicat cannot import excel

angryTom
Release: 2019-08-10 09:15:17
Original
6605 people have browsed it

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!