Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2007
    Posts
    11

    Wink Unanswered: Export to csv file format

    Hi All

    My first time using Access here. I need to export some column to a csv file. How to do it?

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    have a look at the menu option: file | export
    have a look at the help file using the term: export
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2007
    Posts
    11
    don't have? I only see export to Excel, don't have csv

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'm surprised at that....
    scroll down the list...
    read the options

    hint: have a look at the text file choices

    did you have a look at teh help... have a look at delimited file formats whilst you are at it.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Alternatively take a look at
    Code:
    DoCmd.TransferText acExportDelim
    in VBA
    George
    Home | Blog

Posting Permissions

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