What if the navicat imports the xlsx file when the Times is wrong?
What should I do if I make an error in importing xlsx files into navicat? In view of this problem, this article gives the corresponding analysis and answers, hoping to help more friends who want to solve this problem to find a more simple and feasible way.
The reason for the error when navicat imports a file in xlsx format is:
Lack of drivers, you need to go to Microsoft's official website to download AccessDatebaseEngine, the number of digits had better be the same as navicat,office.
After installing the driver, you can successfully import it according to the following process.
1. Open the xlsx file, use navicat for Mysql, and import the Excel file in .xlsx format
2. Select the import format as excel file (.xlsx)
3. Select the import path
On the introduction of navicat xlsx file Times wrong solution to share 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.