title: Exporting Access to CSV
body: <p>I want to export the access query into csv file. For that I am using the following format which was given in the previous discussion in stack overflow. </p>
  
  <pre><code>Function ExportQuery()
      DoCmd.TransferText acExportDelim, , "[your query]", "[output file].csv"
  End Function
  </code></pre>
  
  <p>I get the output as CSV file but the data is separated in the columns of the sheet. I want the data separated by the semi-colon in the first column itself of all the columns.</p>
  
  <p>Please revert back asap.</p>