Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Access - Tilde (~) as the text delimiter when exporting

Posted on 1997-04-30
1
Medium Priority
?
324 Views
Last Modified: 2006-11-17
I want to export from MS Access to a text delimited format using the ~ symbol as the delimiter.  How is this done?
0
Comment
Question by:alligolf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
advapp earned 100 total points
ID: 1008836
If you have Access 95 or better, here's how:
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.
0

Featured Post

[Video] Create a Disruption-Free Workspace

Open offices have their challenges. And Sometimes, it's even hard to work at work. It's time to reclaim your office and create a disruption-free workspace. With the MB 660, you can:

-Increase Concentration
-Improve well-being
-Boost Productivity

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question