title: How do I keep the necessary decimal places when using the DoCmd.TransferText command to export a table to a .csv?
body: <p>I am using the <em>DoCmd.TransferText</em> in MS-Access-2010 VBA to export a table to a .csv file. However when I do this the resulting .csv file truncates the information in the table. For example the longitude -85.350223 becomes -85.35. How do I make it where the resulting .csv file is still comma delimited and keeps the full information from the table?</p>
  
  <p>If I need to create an Import/Export specification and reference it in the command line using the <em>SpecificationName</em> feature of DoCmd.TransferText (assuming I have correctly interpreted this feature as a formatting tool) please explain how to do that.</p>
  
  <p>Here is the line I am currently using to export the file to .csv:</p>
  
  <blockquote>
    <p>DoCmd.TransferText acExportDelim, ,
    "AllMetersAvgRSSI",
    CurrentProject.Path &amp;
    "\AllMetersAvgRSSI.csv"</p>
  </blockquote>