Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fixed Format Exports (Access 97)

    I am trying to export a table in a fixed-width format to a ".csv" file, and cannot get the blasted thing to give me the row headings . What am I doing wrong???

    thanks!

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Fixed Format Exports (Access 97)

    If you are using File / Export to export the .CSV. One of the screens in the export process should have a checkbox that says something like include first row as header. Check the checkbox to get the row headings.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Fixed Format Exports (Access 97)

    If exporting table to text file, you can specify either fixed-width or delimited text format. A .CSV (comma-separated values) file is by definition delimited, not fixed-width. If exporting to delimited format than you can specify this option by checking "Include Field Names on First Row" box, as illustrated. If you export to fixed-width format, you do not have this option.

    HTH
    Attached Images Attached Images

  4. #4
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fixed Format Exports (Access 97)

    Thanks, I'll try it that way.

    Marion

Posting Permissions

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