It seems I CAN open the entire workbook in Word, then save as ASCII text.
This creates a delimited file that Foxpro can read properly.
>Glenn,
>
>Sounds like you're going to have use Office Automation to have VFP open up Excel with the file and grab the data from the various sheets.
>
>PF
>
>>I have tried every which way to import an Office 97 Excel
>>file into VFP 5. I have even tried various Save As options,
>>but they tend to save 1 sheet only and not the whole workbook.
>>
>>Does anyone know how to pull, push or coax a Excel file into
>>Visual Fox or DOS Fox?
>>
>>Thanks,
>>Glenn Abelson
Glenn