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: All
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.