dBase III commands

Question

dBase III commands

elmerfuddd (Programmer)

(OP)

7 Oct 10 02:56

Is there any place where I can find a listing of dBase III commands?

I have some data that I want to convert to a format compatible with Excel, but no longer have the necessary commands.

Trial and error will probably result in just as many errors as trials, and my memory after 25 years is not too good.

Thanks

dbMark (Programmer) · Answer 1 · 2010-10-14 11:35:35

The simplest format to create is a CSV file... Comma Separated Values... I'm not sure if that is in old dBase, but I think it should be. If not, then try specifify delimited

HisName,HisStreet,HisCity,HisState,HisZip
HerName,HerStreet,HerCity,HerState,HerZip

I would hope this might work:

CODE

USE myDBF
COPY TO MyFile.TXT FIELDS <fieldlist> FOR <scope> TYPE CSV
USE

You're right, it's been 20+ years. Perhaps the Help should be enough if you research "COPY TO".

Nifrabar (Programmer) · Answer 2 · 2010-11-10 07:37:07

you also might try to open the file in vfp and export than to typ xl5
-bart

fishmahn (MIS) · Answer 3 · 2010-12-28 17:15:16

elmerfuddd,

In dBase III(+), type Help. That pulls up the help system menu. Also "Help copy" givest the syntax of the copy command.

For your request, it will be:

copy to <filename> delimited

That will create a comma-separated file that Excel can read.

Also, Excel can read old dbf's directly (level 7 databases are not readable). In Excel Go to File/Open and in the dropdown of file types select one of the dbase formats.

Mike.

Come Join Us!

Posting Guidelines

Jobs

dBase III commands