Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Exporting to Text (Access 2003)

    I have a table I am exporting to a .txt file. It is comma delimited.
    My question is this...

    Why, when the number is fixed 4 in the table, is the number in the text file only giving 2 decimal places?
    Date format is another question. The table is set for Short Date, but in the file I am getting date and time.

    I have tried changing the fixed, auto decimal setting in the table. I get the same 2 decimal places in the
    output each time.

    Same for Date. I have tried different setting, but get the date / time each time in the output file.

    Thanks for any help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Exporting to Text (Access 2003)

    You have to keep in mind that the Format property of a field in a table only determines how a field is displayed on-screen, not how the data are stored by Access. Normally, the export procedure only looks at the stored data, not at the way they are formatted. You can tick the "Save formatted" check box in the "Save As" dialog; this will preserve the display formats, but it will result in a file that cannot easily be used as a data file.

Posting Permissions

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