>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 ;
database Sale name ImportedData ;
type XL8 ;
sheet "Sheet1"
PS:Supported in VFP6 and up.
Cetin