Solution to error when navicat imports xlsx format file

The reason why navicat reports an error when importing xlsx format files is:

is missing the driver. You need to go to the Microsoft official website to download AccessDatebaseEngine. The best number of digits is the same as navicat , the office is consistent.

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

After installing the driver, follow The following process can be imported successfully.

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

Recommended tutorial:

mysql tutorial

The above is the detailed content of Solution to error when navicat imports xlsx format file. For more information, please follow other related articles on the PHP Chinese website!