Extracting Structure/Indexes from a FoxPro Database to Excel

Alternatively if you want to pursue the Excel route manually then …

If you have a table MYTABLE.DBF with the following structure:

Structure for table:          C:\TEMP\MYTABLE.DBF
Number of data records:       0       
Date of last update:          01/05/2014
Code Page:                    1252    
 Field  Field Name            Type                        Width      Dec    Index   Collate     Nulls       Next       Step
     1  FIRSTNAME             Character                      20                                    No
     2  LASTNAME              Character                      20                                    No
     3  AGE                   Numeric                         3                                    No
     4  ID                    Integer (AutoInc)               4               Asc   Machine        No          1          1
** Total **                                                  48

Then you can dump the structure to another DBF via the VFP Command Window like this:

cd \temp
use mytable
copy structure extended to mytablestruct.dbf

You can then open the table that contains structure info and dump it to XLS format:

use mytablestruct
copy to struct.xls type xl5

In Excel that will look like:

enter image description here

With regard to indexes you would have to code a small routine like this:

    Create Cursor indexinfo (idxname C(254), idxtype c(254), idxkey c(254), ;
        idxfilter c(254), idxorder c(254), idxcoll c(254))
    Use mytable In 0
    Select mytable
    lnTags = ATagInfo(laTemp)
    For i = 1 to lnTags
        Insert into indexinfo values (laTemp[i, 1], laTemp[i, 2], laTemp[i, 3], laTemp[i, 4], laTemp[i, 5], laTemp[i, 6])
    EndFor
    Select indexinfo
    Copy To indexinfo.xls type xl5

Opening the resultant indexinfo.xls: