Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ExportTo File Specification (Access 2002 sp1)

    I am trying to export a table (using code) to a comma delimited file. Is there a way to designate a predefined file specification when using OutputTo acformatTXT? All I get is a text file (with data) built with dashes and plus signs to look like a table.

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

    Re: ExportTo File Specification (Access 2002 sp1)

    I don't know if this is what you want:

    When you export manually to a text file, using File/Export..., the Export Text Wizard has an Advanced... button. Here you can save your export settings as a specification. You can use this specification later if you use DoCmd.TransferText, not if you use DoCmd.OutputTo:

    DoCmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName)

Posting Permissions

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