Exporting with Double Pipe Delimiter

Copper Contributor

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