Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009

    Unanswered: Decimal digits while exporting tables into txt files


    I need to export some Access tables into .txt files

    When I try to export with Access tool, even if I define Specifications, it exports numbers with decimal digits (i.e. every number ends with ,00 or .00)

    I'd like not to have decimal digits

    Is there a way to do so without writing code?

    Thank you



  2. #2
    Join Date
    May 2005
    Write a SELECT query that grabs all the data you want, except with the field in question you do something like:

    Format([tblName].[fldName], "0")

    Then export the query instead of the table.

    For more help with the Format function see here.

    Alternatlively, I suppose you could use the CLng function.
    Me.Geek = True

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts