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
Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
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.