Excel data refresh
Quote from Andy McIntosh on June 16, 2023, 4:50 pmWe have a list of files that customers currently get from the classic host green screens in CSV or text formats. They then copy them into an excel tab and manually update their report page. Is there a way for RWQ to do the import csv data refresh automatically when it is run?
We have a list of files that customers currently get from the classic host green screens in CSV or text formats. They then copy them into an excel tab and manually update their report page. Is there a way for RWQ to do the import csv data refresh automatically when it is run?
Quote from Andy Weiss on June 20, 2023, 2:04 pmThere is a technique that you can use, assuming the Excel file is importing data from a single csv file. Setup the csv file as an OLEDB or ODBC datasource in ReportWORQ, this is supported by the Microsoft Text Driver . Then use the RWSQL formula to import the data from the CSV file using a SQL query. The RWSQL formula is documented here: Excel Functions.
Thank You,
-Andy
There is a technique that you can use, assuming the Excel file is importing data from a single csv file. Setup the csv file as an OLEDB or ODBC datasource in ReportWORQ, this is supported by the Microsoft Text Driver . Then use the RWSQL formula to import the data from the CSV file using a SQL query. The RWSQL formula is documented here: Excel Functions.
Thank You,
-Andy
Quote from Andy McIntosh on June 20, 2023, 2:20 pmThank you, it will be a big win for us! Does this work in 4.4?
Thank you, it will be a big win for us! Does this work in 4.4?