I have a query called qry_export (SQL Query below if needed) that pulls up a simple query with 2 columns and I want to export the results to a csv file called
Export_MM_DD_YYYY.pft where the MM DD YYYY is of course the date
The format of the csv file needs to be
"PORTFOLIO DESC", "BB TICKER"
I would like to do this via a module if possible. I have used the runsavedimportexport function in the past but in this case I need to put the current date into the file and that will not work for me.
SQL Code for query
SELECT Bb_Alpha1.[PORTFOLIO DESC], Bb_Alpha1.[BB TICKER]
WHERE (((Bb_Alpha1.[PORTFOLIO DESC]) Not Like "*test*") AND ((Bb_Alpha1.[BB TICKER]) Is Not Null));