cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

JMP Knowledge Base

Choose Language Hide Translation Bar
Excel 2007 ODBC driver limits import to 255 columns

Although Excel 2007 allows a worksheet to contain more than 16,000 columns, the Excel 2007 (Excel 12) ODBC driver will limit import to 255 columns.

If the Excel 2007 worksheet you wish to import into JMP® has more than 255 columns, the work around is to open the worksheet in Excel and save it as a delimited file, then import it into JMP as a text file.

 

[Previously JMP Note 33421]

Details
Operating System
Windows

Recommended Articles