Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!ns-mx!umaxc.weeg.uiowa.edu
From: broy@umaxc.weeg.uiowa.edu (Barbara Roy)
Newsgroups: comp.databases
Subject: Re: Writing dBase III+ Data to Files
Message-ID: <1166@ns-mx.uiowa.edu>
Date: 10 Apr 90 14:37:04 GMT
References: <14871@s.ms.uky.edu>
Sender: news@ns-mx.uiowa.edu
Lines: 17

From article <14871@s.ms.uky.edu>, by aaronh@ms.uky.edu (Aaron David Herskowitz):
> Would anyone here know how to "redirect" data from dBase III+ to a
> file?
> 
> I have some data in a database that I would like to put into a text
> file so that I can use it in conjunction with a mail merge.

The easiest way to create a text file from a dBase file is to use the
COPY command with TYPE SDF if you want a straight ASCII file. If you
need the file delimited with commas, quotes, whatever, then use the
COPY command with DELIMITED WITH <delimiter>.

The APPEND command has similar syntax and would allow you to add text
file data into a dBase file if you need to.


Barbara Roy,Weeg Computing Center,University of Iowa,Iowa City,IA. 52244