nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem with Excel

Françoise

hi,

someone has made for me a database with Excel.xlsb.

When I import it, the database opens with Excel.

is there a solution to import it with Jmp?

best regards

Accepted answers

All comments

David_Burnham

I did a quick search and found these: save data table as excel xlsb and How to open .xlsb file?

Françoise

thanks David for your answer.

I 've seen the message of Tom Abramov (2019).

I hoped that someone of the R&D had found a solution because *.xlsb is interesting to reduce the size of the excel files.

best regards

Mark_Bailey

Does the File > Database > Open Table approach work with workbooks saved using the binary XLSB format?

David_Burnham

Could be a good route - The ODBC driver for Excel files supports XLSB formats.

Françoise

I haven't connection in the database Operations

My Jmp is 64 but my Excel is 32 and I'm not used to use ODBC.

I tried with the query builder but it could not be executed.

May be someone else can test it to help others members?

Mark_Zwald

If you are opening Excel files with JMP, make sure the "Use Default Program to Open" box is unchecked when selecting from the File Open dialog window. That way the file opens in JMP rather than the default program (Excel).

Françoise

thanks for your answer,

I 've unchecked, thn it tries to open with JUMP but I have this message:

Sans titre.jpg

best regards

Françoise

and the result for mzwald:

Sans titre.jpg

difficult to analyse and explore Jmp dt....