VFP9\Xsource\Wizards\wzimport\import.h or http://www.xtremevbtalk.com/archive/index.php/t-121161.html


>Thanks a lot Tore, 39 helped. Can you give me define for it, so I would not use the "magic" number?
>
>>>I need to convert a Excel 2007 to dbf
>>>It's worked in Excel 3003
>>>
>>>TIA
>>

>>lcFile='yourfile.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
>>Close Databases all
>>Create table yourtable...
>>Append From (lcFile) xls
>>Erase (lcFile)