cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar

importing from Excel

Sep 16, 2009 02:19 PM (2702 views)
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?
0 Kudos
2 REPLIES 2
sfkeydel
sfkeydel
Level III

Re: importing from Excel

Sep 17, 2009 12:40 AM (2658 views)  |  Posted in reply to message from 09-16-2009
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.
0 Kudos

Re: importing from Excel

Sep 17, 2009 11:44 PM (2658 views)  |  Posted in reply to message from 09-16-2009
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
0 Kudos