Results 1 to 2 of 2
  1. #1
    tcheck is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    131

    Creating Batch File Running Access Query

    I am creating a batch in an Access Query to decompress files that come in from an FTP site. When I right click on the query and export it to a TXT file I get all the line items of the that I want without the header of the query field name. When I run the following command;



    DoCmd.TransferText acExportDelim, "Decompress2 Specification", "qry_FileNameChange2", "J:\operations\Decompress2.txt", True
    (Where "Decompress2 Specification" is the name of the Spec)
    I get the name of the field as the first line item and then all the line items I am looking for. I use the same Spec when I manually run it or when I run it from the code. Any idea how I can get rid of the first line item when I run it from the code?

    I run a batch file to change the txt extension to bat.

  2. #2
    tcheck is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    131
    Never mind, changed the True to False and the header is gone.

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

Similar Threads

  1. Replies: 6
    Last Post: 09-14-2012, 11:58 AM
  2. Replies: 1
    Last Post: 11-28-2011, 12:39 PM
  3. Run batch file
    By shay in forum Access
    Replies: 3
    Last Post: 12-15-2010, 09:47 AM
  4. Running Batch File
    By NoiCe in forum Programming
    Replies: 2
    Last Post: 03-21-2010, 07:05 AM
  5. Creating a Daily Running Total Query
    By seraph in forum Queries
    Replies: 0
    Last Post: 08-15-2009, 12:11 AM

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