Export data from a table to a .txt file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CD Tom
    Contributor
    • Feb 2009
    • 495

    Export data from a table to a .txt file

    I'm having a problem exporting a table that has a field formatted as Field size (Double), Format (standard) and Decimal Places 3. looking at the table everything is fine fields shows 0.624 but when I try to export it to a .txt file if field shows up as 0.62 I've used the External Data and export to Txt file. I've set up a specification with the field type as double but when I export it I don't get the 3 positions. My export code is as follows
    Code:
                Vtable = "scores"
                apppathx = (StrFolderName + "\" + "scores.txt")
                DoCmd.TransferText acExportMerge, "Scores Export Specification", Vtable, apppathx, True
    Any help is greatly appreciated.
Working...