273271_en-US

liliconcom

Problem with Excel

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

Data TableRe: Problem with Excel

Stan,

 

no success with your solution.

 

can you give me the beginning of this script?

 

best regards

Re: Problem with Excel

and the result for mzwald:

 

 

difficult to analyse and explore Jmp dt....

Re: Problem with Excel

dear Stan,

 

I will try it

 

Re: Problem with Excel

thanks for your answer,

 

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

 

 

best regards

Re: Problem with Excel

Hi @Françoise 

If you match the bitness of your ODBC driver to that of JMP it should work.

I was able to import the VA Lung Cancer data provided in the sample data using JMP Query Builder.

 

Import .xlsb file using JMP Query BuilderImport .xlsb file using JMP Query Builder

 

cheers,

Stan

Re: Problem with ExcelIf 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).Re: Problem with Excel

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?

Re: Problem with Excel

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

 

Re: Problem with Excel

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

Re: Problem with Excel

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

Re: Problem with Excel

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