dBase III commands 1

elmerfuddd · Oct 6, 2010

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 · Oct 14, 2010

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 · Nov 10, 2010

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

fishmahn · Dec 28, 2010

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.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

dBase III commands 1

elmerfuddd

Programmer

dbMark

Programmer

Nifrabar

Programmer

fishmahn

MIS

Similar threads

Part and Inventory Search

Sponsor