Thanks a lot Borislav, this is helpful.

this table has close to 205k rows and when i execute teh command you provided for XL5, i see it started but hanging at 16384 rows with excel. seems like that is teh limit i see on google.

is there a way i can export to .csv file, may be that will hold much larger amount of rows than excel file.

or a txt file is also fine with a delimier.

USE DocIndex
COPY TO DocIndex XL5

And the file gets created to which path?

Can i create file in same place as docindex.dbf table folder path or can i specify the file to get created in "c:\myexports"

Kind Regards, thanks a lot for the helpful ino