Refresh Excel SQL quarry before extracting data to JMP

[#1]

Hi,

Just wondering if there is a way to use JMP scripting to refresh data in the Excel workbook before it is being imported to JMP table.

I can't build direct query from JMP to the database because there is too many obstacles like very old and not updatable Acces database on very old tool and differences in bitnes between office and JMP, but I can extract data from the Excel whchi has build in SQL query. 

Looking for way for me to just use the JMP script to open the source Excel file, refresh it with new data and upload to JMP.

Thanks,

Tomasz

[#2]

Maybe you could use VBScript  to update the data. Community most likely has some posts for that. Here is one example Run VBA code in JSL script