BookmarkSubscribeSubscribe to RSS Feed

importing from Excel

I have JMP v8 on a Macintosh with OS 10.5.8

When I try to import data from Excel, the files with xls extension are selectable while those with xlsx are not. Is there any way to select xlsx files?
2 REPLIES
sfkeydel

Community Trekker

Joined:

Jun 23, 2011

Re: importing from Excel

Hi Dan,

I don't believe this is possible; your best bet will be to save the file in Excel 2004 format (.xls), and then import.

Re: importing from Excel

With Excel 2008 Microsoft no longer provides the ODBC driver for Mac OS X. You will have to purchase a 3rd party ODBC driver.

Please refer to this JMP Note for more details:
http://www.jmp.com/support/notes/36/659.html