When I import an Excel 2007 file with more than 255 columns into Navicat, it is truncated to 255 columns.
Apply OS: Windows
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium
Apply Navicat Version No.: Version 8.x or above
It is currently a restriction of Navicat to import more than 255 columns from Excel 2007 file. Although Excel 2007 supports more than 255 columns, Navicat only imports the first 255 columns and ignores the remaining columns.