Solved

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

Posted on 1997-04-30
1
310 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 50 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

A clone is a duplicate copy. Sheep have been cloned and maybe someday even people will be cloned, but disk cloning (performed by the hard drive cloning software) is a vital tool used to manage and protect data. Let’s look at what hard drive cloning …
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses

752 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