Forum Discussion

JabereMS's avatar
JabereMS
Copper Contributor
Jan 14, 2023

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 the relevant direct deits using a Access query per value day. The query result must by exported into a CSV-file. I am failed several times on using the recomended export manager. 

Export to EXCEL and text files in Windows standard or Unicode is furnctioning but the results are not in the shape for a CSV-file. EXCEL and Text files must be converted to CSV afterwards. Also I can create correct CSV files from whole database correctly.

 

What I have to do for creation of CSV-files for preselected database records (by value dates) using a query? 

 

Thanks in advance for your valuable hints

Jakob

  

 

access
office 365
  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    Jan 15, 2023
    another approach:
    Export your Query first to Excel file.
    Open the created excel file and save it as CSV file.
    • JabereMS's avatar
      JabereMS
      Copper Contributor
      Jan 15, 2023

      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.

       

       

      • arnel_gp's avatar
        arnel_gp
        Steel Contributor
        Jan 16, 2023
        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).

Resources