The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
MS Access - Tilde (~) as the text delimiter when exporting
I want to export from MS Access to a text delimited format using the ~ symbol as the delimiter. How is this done?
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
1) Open the database and select the table to export
2) Click on 'File | SaveAs/Export'
3) In the 'SaveAs...' dialog, click on 'To an External File or Database'
4) Click on 'OK'
5) In the 'Save Table..' dialog, click on 'Save as type' and select 'Text Files...'
6) In the 'Export Text' wizard, click on the 'Advanced' button
7) In the 'Client Export Specification' dialog, enter a '~' in the 'Field Delimiter' text field.
From here you can set whatever other options you choose and follow the wizard's instructions.