Any reason you are not using APPEND FROM ?

>Hi all,
>
>I want to import a excel worksheet into a dbf
>
>I use this command :
>
>strconn = "Driver={Microsoft Excel Driver (*.xls)}; DBQ="+ALLTRIM(thisform.filein)+";ReadOnly=1"
>
>slqstrconn = SQLSTRINGCONNECT(strconn)
>sqlexec(slqstrconn , sqlcommand,"MyTable")
>
>After this, I put the MyTable into a grid.
>
>In the DBF file, all field is converting into memo type.
>How can I change this memo type to have character type whitout loose anything
>
>thx.