Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    export table to txt (2000 SP3)

    Wish to export to a text file so that each field comes after the preceding variable, and each variable has the same number of spaces and the field length in the access table. So in case variable 1 that is 12 characters long, and field 2 that 4 character long will look like this.
    abcdefgjij12abcd

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: export table to txt (2000 SP3)

    Select the table in the database window.
    Select File | Export...
    In the "Save as" dropdown list in the dialog, select Text files (*.txt;*.csv;*.tab;*.asc).
    Click Export.
    The Text Export Wizard will start.
    Click Fixed Width, then click Next.
    You can modify the column boundaries if needed.
    Click Next, modify the name if needed, then click Finish.

Posting Permissions

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