Refresh Excel SQL quarry before extracting data to JMP

swiergi11 — Sat, 10 Jun 2023 23:41:30 GMT

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

Re: Refresh Excel SQL quarry before extracting data to JMP

jthi — Wed, 08 Dec 2021 15:40:14 GMT

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

topic Refresh Excel SQL quarry before extracting data to JMP in Discussions

Refresh Excel SQL quarry before extracting data to JMP

Re: Refresh Excel SQL quarry before extracting data to JMP