dBase III commands 1

[elmerfuddd]

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]

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:

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]

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

 

[fishmahn]

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.