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?
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.
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
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.
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.
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");
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.