Home >Database >Mysql Tutorial >Solution to error when navicat imports xlsx format file

Solution to error when navicat imports xlsx format file

王林
王林Original
2019-11-04 09:25:524506browse

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

Solution to error when navicat imports xlsx format file

##2. Select the import format as excel file (.xlsx )

Solution to error when navicat imports xlsx format file

3. Select the import path

Solution to error when navicat imports xlsx format file

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!

Statement:
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