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 that it is not a problem with the software itself.
Related recommendations: "Navicat for mysql graphic tutorial"
Then I went to the Internet to search for the wisdom of the predecessors, and now I have sorted out the solution to this problem, specifically As follows:
(1) Open the excel table and import it.
(2) Navicat and excel are both 64-bit or 32-bit.
(3) The driver is missing. You need to download AccessDatebaseEngine from the Microsoft official website. 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 above is the detailed content of What should I do if navicat fails to import Excel?. For more information, please follow other related articles on the PHP Chinese website!