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.