Results 1 to 4 of 4
  1. #1
    Susy is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2014
    Posts
    134

    vba DoCmd.TransferText acExportDelim, "mySpecOut", "tblExporttoCSV", pathname, True,

    Hi there,



    I need to export table to a .csv file... but with the headers not surrended by doble quotes...

    is it possible?


    Regards,

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    In your Import Spec, be sure to set the Text Qualifier value to NONE instead of the default double-quotes.

  3. #3
    Susy is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2014
    Posts
    134
    Thanks for your answer.. I just want the headers not to have doble quotes... text in the content should have doble quotes, but not the headers.

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I don't think you can do one without the other. I think it is an all or nothing proposition.
    At least in using DoCmd.TransferText. I imagine it can probably be done by creating VBA code to explicitly write out the CSV file, line-by-line.

    One workaround may be to export it without the headers, and just have the headers stored in a separate one line text file that you can append to the top of the file after it is exported.

    Or maybe someone else will have some better ideas.

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

Similar Threads

  1. Replies: 2
    Last Post: 12-23-2015, 09:32 PM
  2. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  3. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  4. Suppress "Error" message following "Cancel = True"
    By GraeagleBill in forum Programming
    Replies: 7
    Last Post: 03-23-2014, 05:40 PM
  5. Replies: 2
    Last Post: 08-31-2006, 12:19 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