Forum Discussion

bird730's avatar
bird730
Copper Contributor
Jan 19, 2021

Exporting with Double Pipe Delimiter

Is there a way export .txt file from Access with a double pipe "||" delimiter? I am able to export with a single pipe "|" via the Export Wizard, but not double. Thank you for your help!  

access

1 Reply

  • tsgiannis's avatar
    tsgiannis
    Iron Contributor
    Jan 20, 2021

    bird730 Well what export wizard won't you can do it with some VBA code

    Check this MS Article: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/freefile-function

     

Resources