Output to a fixed-width text file

Discussion in 'Microsoft Access VBA Modules' started by Scott, Jun 26, 2003.

  1. Scott

    Scott Guest

    I need to create a fixed-width text file from data in my
    Access database. The format for currency values in this
    text file only allows for an implied decimal point. How
    can I remove the decimal point and retain all the digits
    during output to this text file?
     
    Scott, Jun 26, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Steve

    fixed width importing problems

    Steve, Nov 21, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    280
    Joe Fallon
    Nov 23, 2003
  2. Guest

    Import text file (fixed width)

    Guest, Aug 11, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    363
    Allen Browne
    Aug 12, 2005
  3. Guest
    Replies:
    0
    Views:
    344
    Guest
    Jul 11, 2006
  4. vvariety

    Issue with Export Fixed Width and Date field.

    vvariety, Jun 11, 2008, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    285
    Jim Burke in Novi
    Jun 11, 2008
  5. Senexis

    Vertical Fixed Width Import Specification

    Senexis, May 11, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    260
    Senexis
    May 11, 2009
  6. Senexis

    Vertical Fixed Width Import Specification

    Senexis, May 11, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    184
    Senexis
    May 11, 2009
  7. Kaykayme

    Open Fixed Width Text File from Access

    Kaykayme, Jun 17, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    2,312
    Kaykayme
    Jun 17, 2009
  8. Sreedhar

    Export fixed width file from Access 2003

    Sreedhar, Nov 30, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    1,377
    Sreedhar
    Dec 1, 2009
Loading...