Thanks Tore. Got it working.
>Your excel file must be in an older format. Here is my code to do this automatically.
>
>lcFile='c:\mypath\myfile.xls'
>Erase (Forceext(lcFile,'xxx'))
>ox=Createobject('excel.application')
>owb=ox.Workbooks.Open(lcFile)
>lcFile=Forceext(lcFile,'xxx')
>ox.DisplayAlerts= .F.
>owb.SaveAs(lcFile,39)
>owb.close()
>owb=.null.
>ox=.null.
>Release owb
>Release ox
>Select yourtable
>append from (lcFile) xls>
>>Hi All
>>
>>I create an XLS file using Office 2007 but telling it to create a 97/2003 format file. This file will not import into VFP9 using
>>
>>
>>APPEND FROM myfile.xls TYPE XL8
>>
>>
>>It says the file is not in a valid format. Any ideas or suggestions about this?
>
>lcFile='c:\mypath\myfile.xls'
>Erase (Forceext(lcFile,'xxx'))
>ox=Createobject('excel.application')
>owb=ox.Workbooks.Open(lcFile)
>lcFile=Forceext(lcFile,'xxx')
>ox.DisplayAlerts= .F.
>owb.SaveAs(lcFile,39)
>owb.close()
>owb=.null.
>ox=.null.
>Release owb
>Release ox
>append from (lcFile) xls
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
