Can you export the Reports as a CSV file to then import into Excel for filtering?

Stuart John shared this question 3 years ago
Answered

Can the data from the quote reports be extracted as a CSV or delimited text file so it could be imported into Excel?

Best Answer
photo

Currently the printed reports in FastCAM QE are just that, printed only.

However if you have Excel then you can actually create a Data Conneciton inside Excel to the QE database, and then create a SQL Query that can replicate most of the reports in QE. It is fairly simple to do.

This way you can just open the Excel sheet when required a perform a Data Refresh from the menu to get the current live data.


Please contact us directly if you need assistance in setting this up.

Comments (1)

photo
1

Currently the printed reports in FastCAM QE are just that, printed only.

However if you have Excel then you can actually create a Data Conneciton inside Excel to the QE database, and then create a SQL Query that can replicate most of the reports in QE. It is fairly simple to do.

This way you can just open the Excel sheet when required a perform a Data Refresh from the menu to get the current live data.


Please contact us directly if you need assistance in setting this up.