>For importing data i issue this syntax
>import from book1 database sale name importeddata type xl97 sheet sheet1
>An OLE error return. I couldn't understand this error. When i import data from excel4 sheet it imported correctely.
>
>But i want to import from excel97 and want to write a routine in command button so that user click button and data importe automatically.
>Please Guide me.
>
>Nafees

---

Import from book1.xls ;
<del> database Sale name ImportedData ;</del>
 database "Sale" name "ImportedData" ;
 type XL8 ;
 sheet "Sheet1"

PS:Supported in VFP6 and up.
Cetin