Solved

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

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

The Rasberry PI is a low cost piece of hardware that you can have a lot of fun with through experimenting and building/working on projects like media players, running a low cost computer, build data loggers etc. - see: https://www.raspberrypi.org
In the modern office, employees tend to move around the workplace a lot more freely. Conferences, collaborative groups, flexible seating and working from home require a new level of mobility. Technology has not only changed the behavior and the expe…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now