Choose Language Hide Translation Bar
Highlighted
atlas100
Level III

JMP needs ODBC Driver to Open Excel Files

I just upgraded to JMP 11 yesterday. I cannot open Excel files. Doing a Google search I figured out I needed an ODBC driver. I have tried the actual technologies driver, to no avail. the OpenLink website is very confusing. They offer multiple drivers depending on what database you need to get access to. I don't know if Excel is an access database, MySQL, SQL Server or what. I am running JMP on a Mac. If anyone can offer help I would greatly appreciate it!

4 REPLIES 4
Highlighted
markfisher
Level II

Re: JMP needs ODBC Driver to Open Excel Files

Open your ODBC administrator (can be found in your control panel under Administrative Tools, or simply run odbcad32.exe).  Under the User DSN tab, click "add", select the Microsoft Excel driver, the click Finish.  You should be good to go after that.

Highlighted
atlas100
Level III

Re: JMP needs ODBC Driver to Open Excel Files

Thanks for your suggestion. However, I am on a Macintosh.

Highlighted
ms
Super User ms
Super User

Re: JMP needs ODBC Driver to Open Excel Files

Is it .xls or .xlsx? I have not tried JMP 11 yet, but I would be surprised if the ability to directly open "old" excel files is gone. If your file is a .xlsx try to save it as .xls (Excel 97-2004 format).

To open an .xlsx file you probably need an ODBC-driver. Regarding ODBC drivers for Mac I think that it's the one for Access that has the best chance to work with Excel. Years ago I tried their trial version and managed to retrieve data from an Access table. It's read only though.

Highlighted
atlas100
Level III

Re: JMP needs ODBC Driver to Open Excel Files

Saving as .xls worked. Thanks.

Article Labels

    There are no labels assigned to this post.