[comp.databases] Writing dBase III+ Data to Files

aaronh@ms.uky.edu (Aaron David Herskowitz) (04/09/90)

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.

Any suggestions/comments would be greatly appreciated...

-- 
Aaron Herskowitz   <=========> University of Kentucky: Unix Lab Consultant,
aaronh@ms.uky.edu     _kai_    Student Government Computer Systems Manager

broy@umaxc.weeg.uiowa.edu (Barbara Roy) (04/10/90)

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