Yuri

I was able to get all the data in the memo fied by importing the data cell by cell.

Mo

>Something like this:
>

>store SQLSTRINGCONNECT(;
>	"DRIVER={Microsoft Excel Driver (*.xls)};" + ;
>	"FIL=Excel 97;" + ;
>	"DefaultDir=c:\;" + ;
>	"DBQ=c:\cim.xls");
>	TO gnConnHandle
>	>CURSORSETPROP("FetchMemo",.t.,0)   && set cursor properties in advance
>
>*It is important to have " and ' inside select/update statements as  below
>* field names are inherited from the first row in Excel columns
>
>?SQLexec(gnConnHandle, 'select * from "sheet1$"')
>....
>
>

>
>>Hello
>>
>>is there a way to import data from Excel to a memo column (fvp8) having data more than 254 characters?
>>
>>Thanks