>>>Does any know of a program that can convert xslx to xls (capable of being imported VFP) that can be run in batch mode
>>
>>Are you able to use Excel itself? You can programmatically automate Excel from VFP, and instruct it to SaveAs an earlier version.
>>
>>Of course, if you do have the option to automate Excel then you can access the contents of .xlsx files directly without having to use the VFP import function.
>
>Al
>
>Thanks for the answer - yesy I can use Excel - how do I programmatically automate Excel from VFP, and instruct it to SaveAs an earlier version?
>
oXL = CreateObject("Excel.Application")
oXL.Workbooks.Open("YourFile.XLS")
oXL.ActiveWorkbook.Save("YourFile", nDesiredFormat)
oXL.Quit()
Use 56 for Excel 97 format. That said, I don't think newer versions can actually produce an Excel 97 format that VFP can read. You have to go back to Excel 5 format for that to work; I think the constant you want is 39.
Tamar