Results 1 to 4 of 4
  1. #1
    kagoodwin13 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Feb 2012
    Posts
    181

    How to Create Export Specification?

    I am attempting to export a query to a text file. I have been requested to remove double quotes as the text qualifier from the text file.



    I've found the solution to be "create an export specification." I haven't found any code of an export specification though. Can someone help me?

    Code:
    'Export file to directory
        DoCmd.TransferText acExportDelim, ExportSpecifications, "qryWebsiteOrderOutput", txtFilePath, True
    
    ExportSpecifications = ??????

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Manually export a table/qry as ttext click the Advanced bbutton.
    set the export format, SAVE SPEC.
    now use it for all exports.

  3. #3
    kagoodwin13 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Feb 2012
    Posts
    181
    Interesting. That worked. Thank you!

  4. #4
    kagoodwin13 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Feb 2012
    Posts
    181
    Be sure to wrap Export Specification name in quotes as well!

    Code:
    'Export file to directory
        DoCmd.TransferText acExportDelim, "WebsiteOrderOutputExportSpecification", "qryWebsiteOrderOutput", txtFilePath, True

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-25-2016, 03:59 PM
  2. Replies: 2
    Last Post: 05-29-2014, 09:30 PM
  3. Replies: 1
    Last Post: 05-20-2013, 08:02 PM
  4. Replies: 0
    Last Post: 12-03-2010, 04:02 PM
  5. Replies: 1
    Last Post: 03-25-2010, 03:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums