I got this error "Invalid variant type conversion" when I was trying to export a MySQL table into MS Access format. Why is this?
Apply OS: Windows, macOS, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All Windows versions, macOS version 11 or above, Linux version 15 or above
This is probably due to the field incompatibility of between MySQL and MS Access. Fields including date, datetime, enum, blob will need extra care during the Export.