Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Location
    NYC
    Posts
    30

    Angry Unanswered: Need Help with a CSV

    I was able to create a macro and export a query into a CSV file. My only problem is there are quotes "" in my CSV file? Is there a way to get rid of the quotes?

    I'm trying to create a CSV file from Access so I can upload the data into vendor database. The quotes are killing me.

    Can someone plese help me. I've been tyring to do this for 4 hours.
    Thanks
    Wendy

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You can create a Specification in your DB telling MSAccess not to include the quotes, then pass this specification name to your macro.....

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Wait, I'll send you an Example

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Here is a simple example, hope it helps you....
    Attached Files Attached Files

  5. #5
    Join Date
    May 2006
    Location
    NYC
    Posts
    30
    Yes, this helps put it into perspective. I realize there is a "specification table" that needs to be built as well. Thank you, thank you, 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
  •