Glad you figured it out. Office Automation would still be the way to go if you want to create a process that someone could run without too much difficulty. I've created several programs, for users here, that take data from spreadsheets or put data in spreadsheets. It's making life much easier for some of the accounting folk here.

PF

>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