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
(On an infant's shirt): Already smarter than Bush