Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Unanswered: How do I write # to a txt file without carriage returns

    I have a query I need to export as a csv file but I have one field that is a memo field and this is the field I need to remove the carriage returns from.

    I have read the other post for this same thing but it does not seam to work with a query just a table.

    Or am I'm just missing somthing here?

    Danny

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Have you tried the Replace function?
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Dec 2003
    Posts
    3
    I'm not sure how to use it.
    I have looked at the help files and I just do not get it today.

    D

  4. #4
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Replace your memo field's vbCrLf and / or Chr$(13) with a space: ' '
    All code ADO/ADOX unless otherwise specified.
    Mike.

  5. #5
    Join Date
    Dec 2003
    Posts
    3
    Could you give me a example:
    Is this done after I have exported the file or befor the export?

    D

  6. #6
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    In the query you are talking about try:

    expr1: Replace([YourMemoField], vbCrLf, " ")
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

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