Exporting with Double Pipe Delimiter

%3CLINGO-SUB%20id%3D%22lingo-sub-2077364%22%20slang%3D%22en-US%22%3EExporting%20with%20Double%20Pipe%20Delimiter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077364%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20export%20.txt%20file%20from%20Access%20with%20a%20double%20pipe%20%22%7C%7C%22%20delimiter%3F%20I%20am%20able%20to%20export%20with%20a%20single%20pipe%20%22%7C%22%20via%20the%20Export%20Wizard%2C%20but%20not%20double.%20Thank%20you%20for%20your%20help!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2077364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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!  

1 Reply

@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