>code:
>Parameter cXlsname,cSheet
>
>OPEN DATA tempdbc
>IMPORT FROM (cXlsname) DATABASE tempdbc TYPE XL8 SHEET (cSheet)
>
>When using this code VFP ignores the "SHEET" clause are returns the first sheet in the spreadsheet. Can anyone suggest a fix?
I suppose you tried just putting the actual sheet name in quotes? I can tell you that the XL8 clause in vfp6 was never fully implemented, despite the documentation, not all features work, that could be the problem, also.
You could test it by saving as Excel5 ,then trying same command with TYPE XL5 to see if that works...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.