title: How to remove double quotes from a CSV file that generated in Access by DoCmd.TransferText acExportDelim
body: <p>I am using DoCmd.TransferText in MS Access to convert data from a query to a CSV file but there are double quotes around each field. The csv file will be used by an application and do not accept the format.</p>
  
  <p>I know I can do it manually by Access Export wizard and set "Text Qualifier" to 'None' for removing double-quotes, but I need to do it in VBA. I would really appreciate if anyone can help me to do it with VBA</p>
  
  <p>Here is the codes that I am using:
  DoCmd.TransferText acExportDelim, , "tbl_ScrubCSV", "P:\0TPSScrub\" &amp; Instrumentnu &amp; ".csv", False</p>
  
  <p>Expected result should be like:
  <strong>E0A,M.V. KULTUS COVE,.,,,CA</strong></p>
  
  <p>but the CSV file exported like:
  "E0A","M.V. KULTUS COVE",".","","","CA"</p>