How to export JMP Data Tables as different Tabs of an Excel Sheet ?

[#1]

Hi,

I have a couple of JMP Data Tables open and would like to export these as different tabs of one excel sheet.

How can I do this in JMP script?

Thanks,
Aman

[#2 · Accepted solution]

Hello Aman,

JMP does not currently support saving different data tables as worksheets within a single workbook.  The exception is on Windows when a table exceeds the limit for the number of rows in an Excel sheet, it will try to open multiple sheets to accommodate all of the data.  Sorry.

Brian Corcoran

JMP Development

[#3]

I may well be wrong but I thought this was possible using ODBC.

[#4]

I tried something like this.

dt1= Data Table("Input");

dt1<<save database("DSN=Excel Files Aman 2;DBQ=C:\Users\b55019\Desktop\Yield.xls;DriverId=790;FIL=excel12.0;MaxBufferSize=2048;PageTimeout=5;","Raw Data");

Seems to give me an ODBC mismatch error

[#5]

Are your JMP and Excel(or ODBC?) both 32 bit or both 64 bit? Mine aren't so I can't explore this. For ODBC access to work you can't have one 64 bit and the other 32 bit.

[#6]

I have both 32-bit and 64-bit JMP, but if you do not have 32-bit JMP then it is not going to work for you.  Microsoft installers will not allow you to install 64-bit Excel ODBC drivers if you have 32-bit Office already installed.

[#7]

If you have the 32-bit Excel/32-bit JMP combination, something like the following will work:

dt = open("$SAMPLE_DATA/Big Class.jmp");

dt2 = open("$SAMPLE_DATA/Tiretread.jmp");

dt << Save database("DSN=Excel Files;DBQ=C:/Bigc.xlsb;", "BigC");

dt2 << Save database("DSN=Excel Files;DBQ=C:/Bigc.xlsb;", "Tires");

Brian

[#8]

I have a 64 bit JMP and 64 bit Excel combination . The command doesn't seem to work .

Gives me the same ODBC mismatch error .

[#9]

I don't have 64-bit Excel available, so I can't try out that combination.  You might want to try creating a new DSN with the 64-bit ODBC Driver Manager (the one in System->Administrative Tools->Data Sources (ODBC) .  This is assuming you are using Windows.  If you are on the Mac, I'm not sure what the issue might be.

[#10]

I tried to do this on a windows machine . I am still getting the same error.

I wonder if there is a way in VB to do it .