Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006

    Unanswered: converting into cvs format

    I have a code for converting into a cvs format:

    DoCmd.TransferText acExportDelim, "qryDocExportSpecification", "QryDocs", "QryDocs.csv"

    However, the file i get at the end in MyDocuments is an excel file and not a word norepad file. Why is i so and how could i correct this situaion ?

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    No. You are not on drugs. (well, maybe you are, but not because you see excel... ) The file is csv. Your machine just has csv files associated with Excel. (By default, when MS Office is installed, Excel is the default program defined to open csv files)

    Right-click the file, and select Open With..., and then choose notepad. If you ALWAYS want to use notepad as the default app to open csv files, in the Open With menu, when choosing notepad to open the file, also select the checkbox below the app list so as to "Always" use NotePad.
    Last edited by loquin; 09-05-07 at 16:11.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

  3. #3
    Join Date
    Mar 2006
    Thank you !!

Posting Permissions

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