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?
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
Thank you, it will be a big win for us! Does this work in 4.4?