append from .xls version greater than 4.0

[Guest_imported]

Any ideas how I can append from an .xls file
that is greater than 4.0. I am running foxpro 2.6.

My code is as follows:
APPEND FROM (lcPath) TYPE xls

The error that is returned:
"The file from which you are attempting to import
data is not a valid Excel version 2.0 file"

 

[dgrewe]

Excel 4 did not exist when FPW2.6 was created therefore it does not know the table structure of a excel4.x file. You will have to export the data in excel to a dbf file or comma delimited file and append from that file.

David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644