Hi Mohammed,

You cannot import from XLS sheet if is open.
MartinaJ

>hi all,
>i try to convert excel sheet to dbf via this code...
>i got erorr message OLE error code 0x80030020:ashare violation hase occurred.
>
>thanks for help
>
>

>CLOSE all
>SET DATE BRITISH
>SET CENTURY on
>thisform.text9.Value=GETFILE('xls')
>**************************************************
>   declare long ShellExecute in "shell32.dll" ;
>	long hwnd, string lpszOp, ;
>	string lpszFile, string lpszParams, ;
>    string lpszDir, long nShowCmd
>ShellExecute(0,'Open',thisform.text9.Value,'','',1)
>********************************************************
>IMPORT FROM (thisform.text9.value) TYPE xls &&&erorr message
>