Forum Discussion
Export into CSV file from Access query
Hello I have no deep experience on MSO365 ACCESS nor I am experient in Makro programming. I have the following problem I have a database with direct debit with different value days. I select th...
another approach:
Export your Query first to Excel file.
Open the created excel file and save it as CSV file.
Export your Query first to Excel file.
Open the created excel file and save it as CSV file.
Hello arnel_gp
Thanks for the advice. I know this approach, but the goal is running the query and export directly into a CSV file.
The query requesting the value day to export before execution but in case of using the export assistant this request will ot appaer.
- maybe use Form to fetch the "parameter date".
once the date is entered. you create/update a query that will hard-code the date into the query.
then use this new query for your export.
the above can only be done through form and vba (creating/updating a query using querydef).
